Welcome to the World of Pokemon

library(datasets)

First lets bring in the Pokemon dataset.

Pokemon = read.csv(file = 'data/Pokemon.csv')
head(Pokemon)
##   X.                  Name Type.1 Type.2 Total HP Attack Defense Sp..Atk
## 1  1             Bulbasaur  Grass Poison   318 45     49      49      65
## 2  2               Ivysaur  Grass Poison   405 60     62      63      80
## 3  3              Venusaur  Grass Poison   525 80     82      83     100
## 4  3 VenusaurMega Venusaur  Grass Poison   625 80    100     123     122
## 5  4            Charmander   Fire          309 39     52      43      60
## 6  5            Charmeleon   Fire          405 58     64      58      80
##   Sp..Def Speed Generation Legendary
## 1      65    45          1     False
## 2      80    60          1     False
## 3     100    80          1     False
## 4     120    80          1     False
## 5      50    65          1     False
## 6      65    80          1     False



Reasearch Question 1:

What is the most common type for pokemon?

Since there are secondary typing for Pokemon, we will have to combine the observations from the two variables.


But first lets see what the data shows for Pokemon that only have one type.

# this is the Type.2 for charmander
# a Pokemon that has a singular "Fire" type

Pokemon$Type.2[5]
## [1] ""

The data displays a “” or empty for a Pokemon that has to Type.2. This will muddy our data if we’re looking for the most common type, since technically “” is a valid observation as far as the code is concerned.


These are the tables for Type.1 and Type.2 variables.

table(Pokemon$Type.1)
## 
##      Bug     Dark   Dragon Electric    Fairy Fighting     Fire   Flying 
##       69       31       32       44       17       27       52        4 
##    Ghost    Grass   Ground      Ice   Normal   Poison  Psychic     Rock 
##       32       70       32       24       98       28       57       44 
##    Steel    Water 
##       27      112
table(Pokemon$Type.2)
## 
##               Bug     Dark   Dragon Electric    Fairy Fighting     Fire 
##      386        3       20       18        6       23       26       12 
##   Flying    Ghost    Grass   Ground      Ice   Normal   Poison  Psychic 
##       97       14       25       35       14        4       34       33 
##     Rock    Steel    Water 
##       14       22       14
# how many types are in Type.1
length(table(Pokemon$Type.1)) 
## [1] 18
# how many types are in Type.2
length(table(Pokemon$Type.2))
## [1] 19

As you can see there is an extra type in table(Pokemon$Type.2) that is “” with the number 386 to represent all of the observations/Pokemon with “” for Type.2.


This is the combined table of Type.1 and Type.2, minus the empty “” type Now we need to be careful, because this does not represent every Pokemon. As you can see when we look at the sum of the table, it shows 1214 when we only have 800 observations/Pokemon.

combinedTypeTable = (table(Pokemon$Type.1) + table(Pokemon$Type.2)[-1])


paste("The sum is: ", sum(combinedTypeTable))
## [1] "The sum is:  1214"

Finally lets see which type is the most common for pokemon, either as their Type.1 OR their Type.2.

# finds the max(table), and then finds the index of the max value, then returns both the number and its name, in our case the type

combinedTypeTable[which(combinedTypeTable == max(combinedTypeTable))]
## Water 
##   126

As you can see, the most common typing for a Pokemon is Water.

But as always a visualization will help in contextualizing this piece of information.

combinedTypeTable = sort(combinedTypeTable, decreasing=TRUE)
barplot(combinedTypeTable[1:5], main = "TOP 5 MOST COMMON TYPES IN POKEMON", ylab="Frequency", col=c("lightblue"))



Reasearch Question 2: *ADD A “Total” Option to the Final Graph that Shows Total Amount of that Type

What generation has the greatest number of each “type”(Type.1 and Type.2 combined) of Pokemon


First we need to know how many different generations are present in our data.

table(Pokemon$Generation)
## 
##   1   2   3   4   5   6 
## 166 106 160 121 165  82

There are 6 different generations of Pokemon listed in the data, with a varying number of Pokemon for each generation.

Now we need to parse the data so that we can see how many of each type is in each generation.

# table for the number of each Type.1 type for all entries where the Generation is 1
table(Pokemon$Type.1[which(Pokemon$Generation == 1)])
## 
##      Bug   Dragon Electric    Fairy Fighting     Fire    Ghost    Grass 
##       14        3        9        2        7       14        4       13 
##   Ground      Ice   Normal   Poison  Psychic     Rock    Water 
##        8        2       24       14       11       10       31
# table for the number of each Type.2 type for all entries where the Generation is 1
table(Pokemon$Type.2[which(Pokemon$Generation == 1)])
## 
##              Dark   Dragon    Fairy Fighting   Flying    Grass   Ground 
##       88        1        1        3        2       23        2        6 
##      Ice   Poison  Psychic     Rock    Steel    Water 
##        3       22        7        2        2        4
length(table(Pokemon$Type.1[which(Pokemon$Generation == 1)]))
## [1] 15
length(table(Pokemon$Type.2[which(Pokemon$Generation == 1)]))
## [1] 14

But we run in to a problem due to the way that Pokemon types are set up. A Pokemon has one or two types, and the Type.2 is valued the same as Type.1. This means that we need to count both when looking at how many types of each Pokemon are in each generation. For example the first Pokemon in the data, Bulbasaur, would count as both a “Grass” and “Poison” type, with both holding equal weight. This causes discrepancies like we see above, where some types are missing from the Type.2 table and the Type.1 table . We will have to modify the table ourselves to make this work.


Since we will most likely have to do this for every generation, lets make a function that fills in the missing “types” and returns one vector with the combined values for both Type.1 and Type.2

# this function will help us combine the two Type tables int o one table with all unique types from both Type.1 and Type.2, as well as add up duplicates


combineTypeTblByGen = function(generation){
  
  # merging the table of Type.1 and Type.2 for the generation
  mergedTypeTable = merge(table(Pokemon$Type.1[which(Pokemon$Generation == generation)]), table(Pokemon$Type.2[which(Pokemon$Generation == generation)])[-1], all= TRUE)
  
  
  # vector version of the merged tables above
  typeVec = mergedTypeTable[[2]]
  names(typeVec) = mergedTypeTable[[1]]
  
  
  
  # for loop that adds up the repeat values for the types, and then removes the duplicate name+value from the vector
  len = length(typeVec) - 1
  for(i in 1:len){
  
    if(i >= length(typeVec)){break}
  
    else if(names(typeVec[i]) == names(typeVec[i + 1])){

      typeVec[i+1] = typeVec[i] + typeVec[i+1]
      #print(typeVec[i])

      typeVec = typeVec[-c(i)]
  
    }

  }
  
  return(typeVec)
  
  
}


barplot(combineTypeTblByGen(1), las=2, main="Frequency of Types for Generation 1")

The plot above combines frequency of “types” in both Type1 and Type2 for generation 1, and because we have the function combineTypeTblByGen() we are able to replicate this for every other generation as well.


Since we have the combined tables for every generation, we can move on to comparing the generations by Type.

This next function will allow us to see how many of one specific type is in every generation. For example it will allow us to see the number of “Bug” types there are in generation 1 through 6.

# function takes in a character argument that represents a Pokemon Type and returns a vector of length 6, with each index representing the number of that type of pokemon are in that generation number

compareTypeAcrossGen = function(type){
  
  oneTypeAllGensVec = c()
  
  for(i in 1:6){
    
    #print(combineTypeTblByGen(i)[type])
    
    oneTypeAllGensVec[i] = combineTypeTblByGen(i)[type]
   
    
  }

  names(oneTypeAllGensVec) = c("Gen 1", "Gen 2", "Gen 3", "Gen 4", "Gen 5", "Gen 6")
  
  return(oneTypeAllGensVec)

}


compareTypeAcrossGen("Bug")
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6 
##    14    12    14    11    18     3
compareTypeAcrossGen("Dark")
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6 
##     1     8    13     7    16     3
barplot(compareTypeAcrossGen("Bug"), main="Frequency of Bug Types in Each Generation(Gen)", las=2, col = "lightgreen")

We have the comparisons across generations for individual types, but that doesn’t accomplish anything unless we want to create 18 different barplots. Instead lets use the plotly package to create an interactive barplot that shows the frequency of each type across the generations to get a broader understanding of the dataset.

typeByGenTraces[]
## [[1]]
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6 
##    14    12    14    11    18     3 
## 
## [[2]]
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6 
##     4     2    15     4    12     9 
## 
## [[3]]
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6 
##     9     9     5    12    12     3 
## 
## [[4]]
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6 
##     5     8     8     1     3    14 
## 
## [[5]]
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6 
##     9     2     9    10    17     4 
## 
## [[6]]
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6 
##    14    11     9     6    16     8 
## 
## [[7]]
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6 
##     4     1     8     9     9    15 
## 
## [[8]]
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6 
##    15    10    18    17    20    15 
## 
## [[9]]
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6 
##    14    11    16    12    12     2 
## 
## [[10]]
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6 
##     5     5     7     8     9     2 
## 
## [[11]]
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6 
##    24    15    18    18    19     4 
## 
## [[12]]
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6 
##    36     4     5     8     7     2 
## 
## [[13]]
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6 
##    18    10    28    10    16     8 
## 
## [[14]]
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6 
##    12     8    12     7    10     9 
## 
## [[15]]
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6 
##    35    18    31    15    18     9 
## 
## [[16]]
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6 
##     1     8    13     7    16     3 
## 
## [[17]]
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6 
##    23    19    14    16    21     8 
## 
## [[18]]
## Gen 1 Gen 2 Gen 3 Gen 4 Gen 5 Gen 6 
##     2     3    12    12    12     5
q2FinalGraph

Lets do some Querying

library(DBI)
library(RSQLite)
## Warning: package 'RSQLite' was built under R version 4.4.3
drv = dbDriver("SQLite")

pokemonDatabase = dbConnect(drv, dbname = "./data/veekun-pokedex.sqlite")
dbExecute(pokemonDatabase, "PRAGMA foreign_keys = on")
## [1] 0
dbListTables(pokemonDatabase)
##   [1] "abilities"                          "ability_changelog"                 
##   [3] "ability_changelog_prose"            "ability_flavor_text"               
##   [5] "ability_names"                      "ability_prose"                     
##   [7] "berries"                            "berry_firmness"                    
##   [9] "berry_firmness_names"               "berry_flavors"                     
##  [11] "characteristic_text"                "characteristics"                   
##  [13] "conquest_episode_names"             "conquest_episode_warriors"         
##  [15] "conquest_episodes"                  "conquest_kingdom_names"            
##  [17] "conquest_kingdoms"                  "conquest_max_links"                
##  [19] "conquest_move_data"                 "conquest_move_displacement_prose"  
##  [21] "conquest_move_displacements"        "conquest_move_effect_prose"        
##  [23] "conquest_move_effects"              "conquest_move_range_prose"         
##  [25] "conquest_move_ranges"               "conquest_pokemon_abilities"        
##  [27] "conquest_pokemon_evolution"         "conquest_pokemon_moves"            
##  [29] "conquest_pokemon_stats"             "conquest_stat_names"               
##  [31] "conquest_stats"                     "conquest_transformation_pokemon"   
##  [33] "conquest_transformation_warriors"   "conquest_warrior_archetypes"       
##  [35] "conquest_warrior_names"             "conquest_warrior_rank_stat_map"    
##  [37] "conquest_warrior_ranks"             "conquest_warrior_skill_names"      
##  [39] "conquest_warrior_skills"            "conquest_warrior_specialties"      
##  [41] "conquest_warrior_stat_names"        "conquest_warrior_stats"            
##  [43] "conquest_warrior_transformation"    "conquest_warriors"                 
##  [45] "contest_combos"                     "contest_effect_prose"              
##  [47] "contest_effects"                    "contest_type_names"                
##  [49] "contest_types"                      "egg_group_prose"                   
##  [51] "egg_groups"                         "encounter_condition_prose"         
##  [53] "encounter_condition_value_map"      "encounter_condition_value_prose"   
##  [55] "encounter_condition_values"         "encounter_conditions"              
##  [57] "encounter_method_prose"             "encounter_methods"                 
##  [59] "encounter_slots"                    "encounters"                        
##  [61] "evolution_chains"                   "evolution_trigger_prose"           
##  [63] "evolution_triggers"                 "experience"                        
##  [65] "genders"                            "generation_names"                  
##  [67] "generations"                        "growth_rate_prose"                 
##  [69] "growth_rates"                       "item_categories"                   
##  [71] "item_category_prose"                "item_flag_map"                     
##  [73] "item_flag_prose"                    "item_flags"                        
##  [75] "item_flavor_summaries"              "item_flavor_text"                  
##  [77] "item_fling_effect_prose"            "item_fling_effects"                
##  [79] "item_game_indices"                  "item_names"                        
##  [81] "item_pocket_names"                  "item_pockets"                      
##  [83] "item_prose"                         "items"                             
##  [85] "language_names"                     "languages"                         
##  [87] "location_area_encounter_rates"      "location_area_prose"               
##  [89] "location_areas"                     "location_game_indices"             
##  [91] "location_names"                     "locations"                         
##  [93] "machines"                           "move_battle_style_prose"           
##  [95] "move_battle_styles"                 "move_changelog"                    
##  [97] "move_damage_class_prose"            "move_damage_classes"               
##  [99] "move_effect_changelog"              "move_effect_changelog_prose"       
## [101] "move_effect_prose"                  "move_effects"                      
## [103] "move_flag_map"                      "move_flag_prose"                   
## [105] "move_flags"                         "move_flavor_summaries"             
## [107] "move_flavor_text"                   "move_meta"                         
## [109] "move_meta_ailment_names"            "move_meta_ailments"                
## [111] "move_meta_categories"               "move_meta_category_prose"          
## [113] "move_meta_stat_changes"             "move_names"                        
## [115] "move_target_prose"                  "move_targets"                      
## [117] "moves"                              "nature_battle_style_preferences"   
## [119] "nature_names"                       "nature_pokeathlon_stats"           
## [121] "natures"                            "pal_park"                          
## [123] "pal_park_area_names"                "pal_park_areas"                    
## [125] "pokeathlon_stat_names"              "pokeathlon_stats"                  
## [127] "pokedex_prose"                      "pokedex_version_groups"            
## [129] "pokedexes"                          "pokemon"                           
## [131] "pokemon_abilities"                  "pokemon_color_names"               
## [133] "pokemon_colors"                     "pokemon_dex_numbers"               
## [135] "pokemon_egg_groups"                 "pokemon_evolution"                 
## [137] "pokemon_form_generations"           "pokemon_form_names"                
## [139] "pokemon_form_pokeathlon_stats"      "pokemon_forms"                     
## [141] "pokemon_game_indices"               "pokemon_habitat_names"             
## [143] "pokemon_habitats"                   "pokemon_items"                     
## [145] "pokemon_move_method_prose"          "pokemon_move_methods"              
## [147] "pokemon_moves"                      "pokemon_shape_prose"               
## [149] "pokemon_shapes"                     "pokemon_species"                   
## [151] "pokemon_species_flavor_summaries"   "pokemon_species_flavor_text"       
## [153] "pokemon_species_names"              "pokemon_species_prose"             
## [155] "pokemon_stats"                      "pokemon_types"                     
## [157] "region_names"                       "regions"                           
## [159] "stat_names"                         "stats"                             
## [161] "super_contest_combos"               "super_contest_effect_prose"        
## [163] "super_contest_effects"              "type_efficacy"                     
## [165] "type_game_indices"                  "type_names"                        
## [167] "types"                              "version_group_pokemon_move_methods"
## [169] "version_group_regions"              "version_groups"                    
## [171] "version_names"                      "versions"

This database and tables needs to be “cleaned” or organized into the information that I actually need –> practice organizing and putting data togehter with joins
Questions to ask/analyze:
how has the stats fro certain types changed over the course of the generartions?
is this change significant?

Goal 1: Create a table/df with all relevant info like pokemon speciest, pokedex number, stats, moves, pokedex flavor text, habitat, strengths and weaknesses, enocunters, locations, abilities

Goal 2:

Pokedex app? image, stats, and reads pokedex entry? check normality for stats by type

hypothesis: flying types are significantly faster than ground, check?

Research Question 3: How does each individual stat vary across the different types. NOTE: language_id of 9 is English

When I think of flying type Pokemon, I imagine fast aerial predators, so naturally you would think that their speed stat is significantly higher than that of ground/rock types that are usually large boulders and giants. But do the stats, get it?, actually back this up? Lets Find Out!

Step 1: get a data frame with every flying type and their speed stat and every ground type and their speed stat

Lets build this dataframe step by step.
Step 1a: get a dataframe with every Pokemon and its speed stat

dbGetQuery(pokemonDatabase, 
           "PRAGMA FOREIGN_KEY_LIST(pokemon_stats)")
##   id seq   table       from to on_update on_delete match
## 1  0   0   stats    stat_id id NO ACTION NO ACTION  NONE
## 2  1   0 pokemon pokemon_id id NO ACTION NO ACTION  NONE
dbGetQuery(pokemonDatabase, "
           SELECT pokemon_id, identifier, base_stat
           FROM pokemon_stats INNER JOIN stats
           ON pokemon_stats.stat_id = stats.id
           WHERE identifier = 'speed'")
##     pokemon_id identifier base_stat
## 1            1      speed        45
## 2            2      speed        60
## 3            3      speed        80
## 4            4      speed        65
## 5            5      speed        80
## 6            6      speed       100
## 7            7      speed        43
## 8            8      speed        58
## 9            9      speed        78
## 10          10      speed        45
## 11          11      speed        30
## 12          12      speed        70
## 13          13      speed        50
## 14          14      speed        35
## 15          15      speed        75
## 16          16      speed        56
## 17          17      speed        71
## 18          18      speed       101
## 19          19      speed        72
## 20          20      speed        97
## 21          21      speed        70
## 22          22      speed       100
## 23          23      speed        55
## 24          24      speed        80
## 25          25      speed        90
## 26          26      speed       110
## 27          27      speed        40
## 28          28      speed        65
## 29          29      speed        41
## 30          30      speed        56
## 31          31      speed        76
## 32          32      speed        50
## 33          33      speed        65
## 34          34      speed        85
## 35          35      speed        35
## 36          36      speed        60
## 37          37      speed        65
## 38          38      speed       100
## 39          39      speed        20
## 40          40      speed        45
## 41          41      speed        55
## 42          42      speed        90
## 43          43      speed        30
## 44          44      speed        40
## 45          45      speed        50
## 46          46      speed        25
## 47          47      speed        30
## 48          48      speed        45
## 49          49      speed        90
## 50          50      speed        95
## 51          51      speed       120
## 52          52      speed        90
## 53          53      speed       115
## 54          54      speed        55
## 55          55      speed        85
## 56          56      speed        70
## 57          57      speed        95
## 58          58      speed        60
## 59          59      speed        95
## 60          60      speed        90
## 61          61      speed        90
## 62          62      speed        70
## 63          63      speed        90
## 64          64      speed       105
## 65          65      speed       120
## 66          66      speed        35
## 67          67      speed        45
## 68          68      speed        55
## 69          69      speed        40
## 70          70      speed        55
## 71          71      speed        70
## 72          72      speed        70
## 73          73      speed       100
## 74          74      speed        20
## 75          75      speed        35
## 76          76      speed        45
## 77          77      speed        90
## 78          78      speed       105
## 79          79      speed        15
## 80          80      speed        30
## 81          81      speed        45
## 82          82      speed        70
## 83          83      speed        60
## 84          84      speed        75
## 85          85      speed       100
## 86          86      speed        45
## 87          87      speed        70
## 88          88      speed        25
## 89          89      speed        50
## 90          90      speed        40
## 91          91      speed        70
## 92          92      speed        80
## 93          93      speed        95
## 94          94      speed       110
## 95          95      speed        70
## 96          96      speed        42
## 97          97      speed        67
## 98          98      speed        50
## 99          99      speed        75
## 100        100      speed       100
## 101        101      speed       140
## 102        102      speed        40
## 103        103      speed        55
## 104        104      speed        35
## 105        105      speed        45
## 106        106      speed        87
## 107        107      speed        76
## 108        108      speed        30
## 109        109      speed        35
## 110        110      speed        60
## 111        111      speed        25
## 112        112      speed        40
## 113        113      speed        50
## 114        114      speed        60
## 115        115      speed        90
## 116        116      speed        60
## 117        117      speed        85
## 118        118      speed        63
## 119        119      speed        68
## 120        120      speed        85
## 121        121      speed       115
## 122        122      speed        90
## 123        123      speed       105
## 124        124      speed        95
## 125        125      speed       105
## 126        126      speed        93
## 127        127      speed        85
## 128        128      speed       110
## 129        129      speed        80
## 130        130      speed        81
## 131        131      speed        60
## 132        132      speed        48
## 133        133      speed        55
## 134        134      speed        65
## 135        135      speed       130
## 136        136      speed        65
## 137        137      speed        40
## 138        138      speed        35
## 139        139      speed        55
## 140        140      speed        55
## 141        141      speed        80
## 142        142      speed       130
## 143        143      speed        30
## 144        144      speed        85
## 145        145      speed       100
## 146        146      speed        90
## 147        147      speed        50
## 148        148      speed        70
## 149        149      speed        80
## 150        150      speed       130
## 151        151      speed       100
## 152        152      speed        45
## 153        153      speed        60
## 154        154      speed        80
## 155        155      speed        65
## 156        156      speed        80
## 157        157      speed       100
## 158        158      speed        43
## 159        159      speed        58
## 160        160      speed        78
## 161        161      speed        20
## 162        162      speed        90
## 163        163      speed        50
## 164        164      speed        70
## 165        165      speed        55
## 166        166      speed        85
## 167        167      speed        30
## 168        168      speed        40
## 169        169      speed       130
## 170        170      speed        67
## 171        171      speed        67
## 172        172      speed        60
## 173        173      speed        15
## 174        174      speed        15
## 175        175      speed        20
## 176        176      speed        40
## 177        177      speed        70
## 178        178      speed        95
## 179        179      speed        35
## 180        180      speed        45
## 181        181      speed        55
## 182        182      speed        50
## 183        183      speed        40
## 184        184      speed        50
## 185        185      speed        30
## 186        186      speed        70
## 187        187      speed        50
## 188        188      speed        80
## 189        189      speed       110
## 190        190      speed        85
## 191        191      speed        30
## 192        192      speed        30
## 193        193      speed        95
## 194        194      speed        15
## 195        195      speed        35
## 196        196      speed       110
## 197        197      speed        65
## 198        198      speed        91
## 199        199      speed        30
## 200        200      speed        85
## 201        201      speed        48
## 202        202      speed        33
## 203        203      speed        85
## 204        204      speed        15
## 205        205      speed        40
## 206        206      speed        45
## 207        207      speed        85
## 208        208      speed        30
## 209        209      speed        30
## 210        210      speed        45
## 211        211      speed        85
## 212        212      speed        65
## 213        213      speed         5
## 214        214      speed        85
## 215        215      speed       115
## 216        216      speed        40
## 217        217      speed        55
## 218        218      speed        20
## 219        219      speed        30
## 220        220      speed        50
## 221        221      speed        50
## 222        222      speed        35
## 223        223      speed        65
## 224        224      speed        45
## 225        225      speed        75
## 226        226      speed        70
## 227        227      speed        70
## 228        228      speed        65
## 229        229      speed        95
## 230        230      speed        85
## 231        231      speed        40
## 232        232      speed        50
## 233        233      speed        60
## 234        234      speed        85
## 235        235      speed        75
## 236        236      speed        35
## 237        237      speed        70
## 238        238      speed        65
## 239        239      speed        95
## 240        240      speed        83
## 241        241      speed       100
## 242        242      speed        55
## 243        243      speed       115
## 244        244      speed       100
## 245        245      speed        85
## 246        246      speed        41
## 247        247      speed        51
## 248        248      speed        61
## 249        249      speed       110
## 250        250      speed        90
## 251        251      speed       100
## 252        252      speed        70
## 253        253      speed        95
## 254        254      speed       120
## 255        255      speed        45
## 256        256      speed        55
## 257        257      speed        80
## 258        258      speed        40
## 259        259      speed        50
## 260        260      speed        60
## 261        261      speed        35
## 262        262      speed        70
## 263        263      speed        60
## 264        264      speed       100
## 265        265      speed        20
## 266        266      speed        15
## 267        267      speed        65
## 268        268      speed        15
## 269        269      speed        65
## 270        270      speed        30
## 271        271      speed        50
## 272        272      speed        70
## 273        273      speed        30
## 274        274      speed        60
## 275        275      speed        80
## 276        276      speed        85
## 277        277      speed       125
## 278        278      speed        85
## 279        279      speed        65
## 280        280      speed        40
## 281        281      speed        50
## 282        282      speed        80
## 283        283      speed        65
## 284        284      speed        60
## 285        285      speed        35
## 286        286      speed        70
## 287        287      speed        30
## 288        288      speed        90
## 289        289      speed       100
## 290        290      speed        40
## 291        291      speed       160
## 292        292      speed        40
## 293        293      speed        28
## 294        294      speed        48
## 295        295      speed        68
## 296        296      speed        25
## 297        297      speed        50
## 298        298      speed        20
## 299        299      speed        30
## 300        300      speed        50
## 301        301      speed        70
## 302        302      speed        50
## 303        303      speed        50
## 304        304      speed        30
## 305        305      speed        40
## 306        306      speed        50
## 307        307      speed        60
## 308        308      speed        80
## 309        309      speed        65
## 310        310      speed       105
## 311        311      speed        95
## 312        312      speed        95
## 313        313      speed        85
## 314        314      speed        85
## 315        315      speed        65
## 316        316      speed        40
## 317        317      speed        55
## 318        318      speed        65
## 319        319      speed        95
## 320        320      speed        60
## 321        321      speed        60
## 322        322      speed        35
## 323        323      speed        40
## 324        324      speed        20
## 325        325      speed        60
## 326        326      speed        80
## 327        327      speed        60
## 328        328      speed        10
## 329        329      speed        70
## 330        330      speed       100
## 331        331      speed        35
## 332        332      speed        55
## 333        333      speed        50
## 334        334      speed        80
## 335        335      speed        90
## 336        336      speed        65
## 337        337      speed        70
## 338        338      speed        70
## 339        339      speed        60
## 340        340      speed        60
## 341        341      speed        35
## 342        342      speed        55
## 343        343      speed        55
## 344        344      speed        75
## 345        345      speed        23
## 346        346      speed        43
## 347        347      speed        75
## 348        348      speed        45
## 349        349      speed        80
## 350        350      speed        81
## 351        351      speed        70
## 352        352      speed        40
## 353        353      speed        45
## 354        354      speed        65
## 355        355      speed        25
## 356        356      speed        25
## 357        357      speed        51
## 358        358      speed        65
## 359        359      speed        75
## 360        360      speed        23
## 361        361      speed        50
## 362        362      speed        80
## 363        363      speed        25
## 364        364      speed        45
## 365        365      speed        65
## 366        366      speed        32
## 367        367      speed        52
## 368        368      speed        52
## 369        369      speed        55
## 370        370      speed        97
## 371        371      speed        50
## 372        372      speed        50
## 373        373      speed       100
## 374        374      speed        30
## 375        375      speed        50
## 376        376      speed        70
## 377        377      speed        50
## 378        378      speed        50
## 379        379      speed        50
## 380        380      speed       110
## 381        381      speed       110
## 382        382      speed        90
## 383        383      speed        90
## 384        384      speed        95
## 385        385      speed       100
## 386        386      speed       150
## 387        387      speed        31
## 388        388      speed        36
## 389        389      speed        56
## 390        390      speed        61
## 391        391      speed        81
## 392        392      speed       108
## 393        393      speed        40
## 394        394      speed        50
## 395        395      speed        60
## 396        396      speed        60
## 397        397      speed        80
## 398        398      speed       100
## 399        399      speed        31
## 400        400      speed        71
## 401        401      speed        25
## 402        402      speed        65
## 403        403      speed        45
## 404        404      speed        60
## 405        405      speed        70
## 406        406      speed        55
## 407        407      speed        90
## 408        408      speed        58
## 409        409      speed        58
## 410        410      speed        30
## 411        411      speed        30
## 412        412      speed        36
## 413        413      speed        36
## 414        414      speed        66
## 415        415      speed        70
## 416        416      speed        40
## 417        417      speed        95
## 418        418      speed        85
## 419        419      speed       115
## 420        420      speed        35
## 421        421      speed        85
## 422        422      speed        34
## 423        423      speed        39
## 424        424      speed       115
## 425        425      speed        70
## 426        426      speed        80
## 427        427      speed        85
## 428        428      speed       105
## 429        429      speed       105
## 430        430      speed        71
## 431        431      speed        85
## 432        432      speed       112
## 433        433      speed        45
## 434        434      speed        74
## 435        435      speed        84
## 436        436      speed        23
## 437        437      speed        33
## 438        438      speed        10
## 439        439      speed        60
## 440        440      speed        30
## 441        441      speed        91
## 442        442      speed        35
## 443        443      speed        42
## 444        444      speed        82
## 445        445      speed       102
## 446        446      speed         5
## 447        447      speed        60
## 448        448      speed        90
## 449        449      speed        32
## 450        450      speed        47
## 451        451      speed        65
## 452        452      speed        95
## 453        453      speed        50
## 454        454      speed        85
## 455        455      speed        46
## 456        456      speed        66
## 457        457      speed        91
## 458        458      speed        50
## 459        459      speed        40
## 460        460      speed        60
## 461        461      speed       125
## 462        462      speed        60
## 463        463      speed        50
## 464        464      speed        40
## 465        465      speed        50
## 466        466      speed        95
## 467        467      speed        83
## 468        468      speed        80
## 469        469      speed        95
## 470        470      speed        95
## 471        471      speed        65
## 472        472      speed        95
## 473        473      speed        80
## 474        474      speed        90
## 475        475      speed        80
## 476        476      speed        40
## 477        477      speed        45
## 478        478      speed       110
## 479        479      speed        91
## 480        480      speed        95
## 481        481      speed        80
## 482        482      speed       115
## 483        483      speed        90
## 484        484      speed       100
## 485        485      speed        77
## 486        486      speed       100
## 487        487      speed        90
## 488        488      speed        85
## 489        489      speed        80
## 490        490      speed       100
## 491        491      speed       125
## 492        492      speed       100
## 493        493      speed       120
## 494        494      speed       100
## 495        495      speed        63
## 496        496      speed        83
## 497        497      speed       113
## 498        498      speed        45
## 499        499      speed        55
## 500        500      speed        65
## 501        501      speed        45
## 502        502      speed        60
## 503        503      speed        70
## 504        504      speed        42
## 505        505      speed        77
## 506        506      speed        55
## 507        507      speed        60
## 508        508      speed        80
## 509        509      speed        66
## 510        510      speed       106
## 511        511      speed        64
## 512        512      speed       101
## 513        513      speed        64
## 514        514      speed       101
## 515        515      speed        64
## 516        516      speed       101
## 517        517      speed        24
## 518        518      speed        29
## 519        519      speed        43
## 520        520      speed        65
## 521        521      speed        93
## 522        522      speed        76
## 523        523      speed       116
## 524        524      speed        15
## 525        525      speed        20
## 526        526      speed        25
## 527        527      speed        72
## 528        528      speed       114
## 529        529      speed        68
## 530        530      speed        88
## 531        531      speed        50
## 532        532      speed        35
## 533        533      speed        40
## 534        534      speed        45
## 535        535      speed        64
## 536        536      speed        69
## 537        537      speed        74
## 538        538      speed        45
## 539        539      speed        85
## 540        540      speed        42
## 541        541      speed        42
## 542        542      speed        92
## 543        543      speed        57
## 544        544      speed        47
## 545        545      speed       112
## 546        546      speed        66
## 547        547      speed       116
## 548        548      speed        30
## 549        549      speed        90
## 550        550      speed        98
## 551        551      speed        65
## 552        552      speed        74
## 553        553      speed        92
## 554        554      speed        50
## 555        555      speed        95
## 556        556      speed        60
## 557        557      speed        55
## 558        558      speed        45
## 559        559      speed        48
## 560        560      speed        58
## 561        561      speed        97
## 562        562      speed        30
## 563        563      speed        30
## 564        564      speed        22
## 565        565      speed        32
## 566        566      speed        70
## 567        567      speed       110
## 568        568      speed        65
## 569        569      speed        75
## 570        570      speed        65
## 571        571      speed       105
## 572        572      speed        75
## 573        573      speed       115
## 574        574      speed        45
## 575        575      speed        55
## 576        576      speed        65
## 577        577      speed        20
## 578        578      speed        30
## 579        579      speed        30
## 580        580      speed        55
## 581        581      speed        98
## 582        582      speed        44
## 583        583      speed        59
## 584        584      speed        79
## 585        585      speed        75
## 586        586      speed        95
## 587        587      speed       103
## 588        588      speed        60
## 589        589      speed        20
## 590        590      speed        15
## 591        591      speed        30
## 592        592      speed        40
## 593        593      speed        60
## 594        594      speed        65
## 595        595      speed        65
## 596        596      speed       108
## 597        597      speed        10
## 598        598      speed        20
## 599        599      speed        30
## 600        600      speed        50
## 601        601      speed        90
## 602        602      speed        60
## 603        603      speed        40
## 604        604      speed        50
## 605        605      speed        30
## 606        606      speed        40
## 607        607      speed        20
## 608        608      speed        55
## 609        609      speed        80
## 610        610      speed        57
## 611        611      speed        67
## 612        612      speed        97
## 613        613      speed        40
## 614        614      speed        50
## 615        615      speed       105
## 616        616      speed        25
## 617        617      speed       145
## 618        618      speed        32
## 619        619      speed        65
## 620        620      speed       105
## 621        621      speed        48
## 622        622      speed        35
## 623        623      speed        55
## 624        624      speed        60
## 625        625      speed        70
## 626        626      speed        55
## 627        627      speed        60
## 628        628      speed        80
## 629        629      speed        60
## 630        630      speed        80
## 631        631      speed        65
## 632        632      speed       109
## 633        633      speed        38
## 634        634      speed        58
## 635        635      speed        98
## 636        636      speed        60
## 637        637      speed       100
## 638        638      speed       108
## 639        639      speed       108
## 640        640      speed       108
## 641        641      speed       111
## 642        642      speed       111
## 643        643      speed        90
## 644        644      speed        90
## 645        645      speed       101
## 646        646      speed        95
## 647        647      speed       108
## 648        648      speed        90
## 649        649      speed        99
## 650        650      speed        38
## 651        651      speed        57
## 652        652      speed        64
## 653        653      speed        60
## 654        654      speed        73
## 655        655      speed       104
## 656        656      speed        71
## 657        657      speed        97
## 658        658      speed       122
## 659        659      speed        57
## 660        660      speed        78
## 661        661      speed        62
## 662        662      speed        84
## 663        663      speed       126
## 664        664      speed        35
## 665        665      speed        29
## 666        666      speed        89
## 667        667      speed        72
## 668        668      speed       106
## 669        669      speed        42
## 670        670      speed        52
## 671        671      speed        75
## 672        672      speed        52
## 673        673      speed        68
## 674        674      speed        43
## 675        675      speed        58
## 676        676      speed       102
## 677        677      speed        68
## 678        678      speed       104
## 679        679      speed        28
## 680        680      speed        35
## 681        681      speed        60
## 682        682      speed        23
## 683        683      speed        29
## 684        684      speed        49
## 685        685      speed        72
## 686        686      speed        45
## 687        687      speed        73
## 688        688      speed        50
## 689        689      speed        68
## 690        690      speed        30
## 691        691      speed        44
## 692        692      speed        44
## 693        693      speed        59
## 694        694      speed        70
## 695        695      speed       109
## 696        696      speed        48
## 697        697      speed        71
## 698        698      speed        46
## 699        699      speed        58
## 700        700      speed        60
## 701        701      speed       118
## 702        702      speed       101
## 703        703      speed        50
## 704        704      speed        40
## 705        705      speed        60
## 706        706      speed        80
## 707        707      speed        75
## 708        708      speed        38
## 709        709      speed        56
## 710        710      speed        51
## 711        711      speed        84
## 712        712      speed        28
## 713        713      speed        28
## 714        714      speed        55
## 715        715      speed       123
## 716        716      speed        99
## 717        717      speed        99
## 718        718      speed        95
## 719        719      speed        50
## 720        720      speed        70
## 721        721      speed        70
## 722      10001      speed       150
## 723      10002      speed        90
## 724      10003      speed       180
## 725      10004      speed        36
## 726      10005      speed        36
## 727      10006      speed       127
## 728      10007      speed        90
## 729      10008      speed        86
## 730      10009      speed        86
## 731      10010      speed        86
## 732      10011      speed        86
## 733      10012      speed        86
## 734      10013      speed        70
## 735      10014      speed        70
## 736      10015      speed        70
## 737      10016      speed        98
## 738      10017      speed        55
## 739      10018      speed       128
## 740      10019      speed       121
## 741      10020      speed       101
## 742      10021      speed        91
## 743      10022      speed        95
## 744      10023      speed        95
## 745      10024      speed       108
## 746      10025      speed       104
## 747      10026      speed        60
## 748      10027      speed        56
## 749      10028      speed        46
## 750      10029      speed        41
## 751      10030      speed        99
## 752      10031      speed        69
## 753      10032      speed        54
## 754      10033      speed        80
## 755      10034      speed       100
## 756      10035      speed       100
## 757      10036      speed        78
## 758      10037      speed       150
## 759      10038      speed       130
## 760      10039      speed       100
## 761      10040      speed       105
## 762      10041      speed        81
## 763      10042      speed       150
## 764      10043      speed       130
## 765      10044      speed       140
## 766      10045      speed        45
## 767      10046      speed        75
## 768      10047      speed        75
## 769      10048      speed       115
## 770      10049      speed        71
## 771      10050      speed       100
## 772      10051      speed       100
## 773      10052      speed        50
## 774      10053      speed        50
## 775      10054      speed       100
## 776      10055      speed       135
## 777      10056      speed        75
## 778      10057      speed       115
## 779      10058      speed        92
## 780      10059      speed       112
## 781      10060      speed        30
## 782      10061      speed        92
## 783      10062      speed       110
## 784      10063      speed       110
## 785      10064      speed        70
## 786      10065      speed       145
## 787      10066      speed        20
## 788      10067      speed        80
## 789      10068      speed       110
## 790      10069      speed        50
## 791      10070      speed       105
## 792      10071      speed        30
## 793      10072      speed        30
## 794      10073      speed       121
## 795      10074      speed       100
## 796      10075      speed       110
## 797      10076      speed       110
## 798      10077      speed        90
## 799      10078      speed        90
## 800      10079      speed       115
## 801      10080      speed        90
## 802      10081      speed        90
## 803      10082      speed        90
## 804      10083      speed        90
## 805      10084      speed        90
## 806      10085      speed        90
## 807      10086      speed        80
## 808      10087      speed        20
## 809      10088      speed       135
## 810      10089      speed       120
## 811      10090      speed       145

Step 1b: dataframe with every flying and ground type

# dbGetQuery(pokemonDatabase, "
#            SELECT *
#            FROM pokemon_types")
# 
# dbGetQuery(pokemonDatabase, "
#            PRAGMA FOREIGN_KEY_LIST(pokemon_types)")
# 
# dbGetQuery(pokemonDatabase, "
#            SELECT *
#            FROM types")

dbGetQuery(pokemonDatabase, "
           SELECT pokemon_id, slot, identifier as TYPE
           FROM pokemon_types INNER JOIN types
           ON pokemon_types.type_id = types.id
          ")
##      pokemon_id slot     TYPE
## 1             1    1    grass
## 2             1    2   poison
## 3             2    1    grass
## 4             2    2   poison
## 5             3    1    grass
## 6             3    2   poison
## 7             4    1     fire
## 8             5    1     fire
## 9             6    1     fire
## 10            6    2   flying
## 11            7    1    water
## 12            8    1    water
## 13            9    1    water
## 14           10    1      bug
## 15           11    1      bug
## 16           12    1      bug
## 17           12    2   flying
## 18           13    1      bug
## 19           13    2   poison
## 20           14    1      bug
## 21           14    2   poison
## 22           15    1      bug
## 23           15    2   poison
## 24           16    1   normal
## 25           16    2   flying
## 26           17    1   normal
## 27           17    2   flying
## 28           18    1   normal
## 29           18    2   flying
## 30           19    1   normal
## 31           20    1   normal
## 32           21    1   normal
## 33           21    2   flying
## 34           22    1   normal
## 35           22    2   flying
## 36           23    1   poison
## 37           24    1   poison
## 38           25    1 electric
## 39           26    1 electric
## 40           27    1   ground
## 41           28    1   ground
## 42           29    1   poison
## 43           30    1   poison
## 44           31    1   poison
## 45           31    2   ground
## 46           32    1   poison
## 47           33    1   poison
## 48           34    1   poison
## 49           34    2   ground
## 50           35    1    fairy
## 51           36    1    fairy
## 52           37    1     fire
## 53           38    1     fire
## 54           39    1   normal
## 55           39    2    fairy
## 56           40    1   normal
## 57           40    2    fairy
## 58           41    1   poison
## 59           41    2   flying
## 60           42    1   poison
## 61           42    2   flying
## 62           43    1    grass
## 63           43    2   poison
## 64           44    1    grass
## 65           44    2   poison
## 66           45    1    grass
## 67           45    2   poison
## 68           46    1      bug
## 69           46    2    grass
## 70           47    1      bug
## 71           47    2    grass
## 72           48    1      bug
## 73           48    2   poison
## 74           49    1      bug
## 75           49    2   poison
## 76           50    1   ground
## 77           51    1   ground
## 78           52    1   normal
## 79           53    1   normal
## 80           54    1    water
## 81           55    1    water
## 82           56    1 fighting
## 83           57    1 fighting
## 84           58    1     fire
## 85           59    1     fire
## 86           60    1    water
## 87           61    1    water
## 88           62    1    water
## 89           62    2 fighting
## 90           63    1  psychic
## 91           64    1  psychic
## 92           65    1  psychic
## 93           66    1 fighting
## 94           67    1 fighting
## 95           68    1 fighting
## 96           69    1    grass
## 97           69    2   poison
## 98           70    1    grass
## 99           70    2   poison
## 100          71    1    grass
## 101          71    2   poison
## 102          72    1    water
## 103          72    2   poison
## 104          73    1    water
## 105          73    2   poison
## 106          74    1     rock
## 107          74    2   ground
## 108          75    1     rock
## 109          75    2   ground
## 110          76    1     rock
## 111          76    2   ground
## 112          77    1     fire
## 113          78    1     fire
## 114          79    1    water
## 115          79    2  psychic
## 116          80    1    water
## 117          80    2  psychic
## 118          81    1 electric
## 119          81    2    steel
## 120          82    1 electric
## 121          82    2    steel
## 122          83    1   normal
## 123          83    2   flying
## 124          84    1   normal
## 125          84    2   flying
## 126          85    1   normal
## 127          85    2   flying
## 128          86    1    water
## 129          87    1    water
## 130          87    2      ice
## 131          88    1   poison
## 132          89    1   poison
## 133          90    1    water
## 134          91    1    water
## 135          91    2      ice
## 136          92    1    ghost
## 137          92    2   poison
## 138          93    1    ghost
## 139          93    2   poison
## 140          94    1    ghost
## 141          94    2   poison
## 142          95    1     rock
## 143          95    2   ground
## 144          96    1  psychic
## 145          97    1  psychic
## 146          98    1    water
## 147          99    1    water
## 148         100    1 electric
## 149         101    1 electric
## 150         102    1    grass
## 151         102    2  psychic
## 152         103    1    grass
## 153         103    2  psychic
## 154         104    1   ground
## 155         105    1   ground
## 156         106    1 fighting
## 157         107    1 fighting
## 158         108    1   normal
## 159         109    1   poison
## 160         110    1   poison
## 161         111    1   ground
## 162         111    2     rock
## 163         112    1   ground
## 164         112    2     rock
## 165         113    1   normal
## 166         114    1    grass
## 167         115    1   normal
## 168         116    1    water
## 169         117    1    water
## 170         118    1    water
## 171         119    1    water
## 172         120    1    water
## 173         121    1    water
## 174         121    2  psychic
## 175         122    1  psychic
## 176         122    2    fairy
## 177         123    1      bug
## 178         123    2   flying
## 179         124    1      ice
## 180         124    2  psychic
## 181         125    1 electric
## 182         126    1     fire
## 183         127    1      bug
## 184         128    1   normal
## 185         129    1    water
## 186         130    1    water
## 187         130    2   flying
## 188         131    1    water
## 189         131    2      ice
## 190         132    1   normal
## 191         133    1   normal
## 192         134    1    water
## 193         135    1 electric
## 194         136    1     fire
## 195         137    1   normal
## 196         138    1     rock
## 197         138    2    water
## 198         139    1     rock
## 199         139    2    water
## 200         140    1     rock
## 201         140    2    water
## 202         141    1     rock
## 203         141    2    water
## 204         142    1     rock
## 205         142    2   flying
## 206         143    1   normal
## 207         144    1      ice
## 208         144    2   flying
## 209         145    1 electric
## 210         145    2   flying
## 211         146    1     fire
## 212         146    2   flying
## 213         147    1   dragon
## 214         148    1   dragon
## 215         149    1   dragon
## 216         149    2   flying
## 217         150    1  psychic
## 218         151    1  psychic
## 219         152    1    grass
## 220         153    1    grass
## 221         154    1    grass
## 222         155    1     fire
## 223         156    1     fire
## 224         157    1     fire
## 225         158    1    water
## 226         159    1    water
## 227         160    1    water
## 228         161    1   normal
## 229         162    1   normal
## 230         163    1   normal
## 231         163    2   flying
## 232         164    1   normal
## 233         164    2   flying
## 234         165    1      bug
## 235         165    2   flying
## 236         166    1      bug
## 237         166    2   flying
## 238         167    1      bug
## 239         167    2   poison
## 240         168    1      bug
## 241         168    2   poison
## 242         169    1   poison
## 243         169    2   flying
## 244         170    1    water
## 245         170    2 electric
## 246         171    1    water
## 247         171    2 electric
## 248         172    1 electric
## 249         173    1    fairy
## 250         174    1   normal
## 251         174    2    fairy
## 252         175    1    fairy
## 253         176    1    fairy
## 254         176    2   flying
## 255         177    1  psychic
## 256         177    2   flying
## 257         178    1  psychic
## 258         178    2   flying
## 259         179    1 electric
## 260         180    1 electric
## 261         181    1 electric
## 262         182    1    grass
## 263         183    1    water
## 264         183    2    fairy
## 265         184    1    water
## 266         184    2    fairy
## 267         185    1     rock
## 268         186    1    water
## 269         187    1    grass
## 270         187    2   flying
## 271         188    1    grass
## 272         188    2   flying
## 273         189    1    grass
## 274         189    2   flying
## 275         190    1   normal
## 276         191    1    grass
## 277         192    1    grass
## 278         193    1      bug
## 279         193    2   flying
## 280         194    1    water
## 281         194    2   ground
## 282         195    1    water
## 283         195    2   ground
## 284         196    1  psychic
## 285         197    1     dark
## 286         198    1     dark
## 287         198    2   flying
## 288         199    1    water
## 289         199    2  psychic
## 290         200    1    ghost
## 291         201    1  psychic
## 292         202    1  psychic
## 293         203    1   normal
## 294         203    2  psychic
## 295         204    1      bug
## 296         205    1      bug
## 297         205    2    steel
## 298         206    1   normal
## 299         207    1   ground
## 300         207    2   flying
## 301         208    1    steel
## 302         208    2   ground
## 303         209    1    fairy
## 304         210    1    fairy
## 305         211    1    water
## 306         211    2   poison
## 307         212    1      bug
## 308         212    2    steel
## 309         213    1      bug
## 310         213    2     rock
## 311         214    1      bug
## 312         214    2 fighting
## 313         215    1     dark
## 314         215    2      ice
## 315         216    1   normal
## 316         217    1   normal
## 317         218    1     fire
## 318         219    1     fire
## 319         219    2     rock
## 320         220    1      ice
## 321         220    2   ground
## 322         221    1      ice
## 323         221    2   ground
## 324         222    1    water
## 325         222    2     rock
## 326         223    1    water
## 327         224    1    water
## 328         225    1      ice
## 329         225    2   flying
## 330         226    1    water
## 331         226    2   flying
## 332         227    1    steel
## 333         227    2   flying
## 334         228    1     dark
## 335         228    2     fire
## 336         229    1     dark
## 337         229    2     fire
## 338         230    1    water
## 339         230    2   dragon
## 340         231    1   ground
## 341         232    1   ground
## 342         233    1   normal
## 343         234    1   normal
## 344         235    1   normal
## 345         236    1 fighting
## 346         237    1 fighting
## 347         238    1      ice
## 348         238    2  psychic
## 349         239    1 electric
## 350         240    1     fire
## 351         241    1   normal
## 352         242    1   normal
## 353         243    1 electric
## 354         244    1     fire
## 355         245    1    water
## 356         246    1     rock
## 357         246    2   ground
## 358         247    1     rock
## 359         247    2   ground
## 360         248    1     rock
## 361         248    2     dark
## 362         249    1  psychic
## 363         249    2   flying
## 364         250    1     fire
## 365         250    2   flying
## 366         251    1  psychic
## 367         251    2    grass
## 368         252    1    grass
## 369         253    1    grass
## 370         254    1    grass
## 371         255    1     fire
## 372         256    1     fire
## 373         256    2 fighting
## 374         257    1     fire
## 375         257    2 fighting
## 376         258    1    water
## 377         259    1    water
## 378         259    2   ground
## 379         260    1    water
## 380         260    2   ground
## 381         261    1     dark
## 382         262    1     dark
## 383         263    1   normal
## 384         264    1   normal
## 385         265    1      bug
## 386         266    1      bug
## 387         267    1      bug
## 388         267    2   flying
## 389         268    1      bug
## 390         269    1      bug
## 391         269    2   poison
## 392         270    1    water
## 393         270    2    grass
## 394         271    1    water
## 395         271    2    grass
## 396         272    1    water
## 397         272    2    grass
## 398         273    1    grass
## 399         274    1    grass
## 400         274    2     dark
## 401         275    1    grass
## 402         275    2     dark
## 403         276    1   normal
## 404         276    2   flying
## 405         277    1   normal
## 406         277    2   flying
## 407         278    1    water
## 408         278    2   flying
## 409         279    1    water
## 410         279    2   flying
## 411         280    1  psychic
## 412         280    2    fairy
## 413         281    1  psychic
## 414         281    2    fairy
## 415         282    1  psychic
## 416         282    2    fairy
## 417         283    1      bug
## 418         283    2    water
## 419         284    1      bug
## 420         284    2   flying
## 421         285    1    grass
## 422         286    1    grass
## 423         286    2 fighting
## 424         287    1   normal
## 425         288    1   normal
## 426         289    1   normal
## 427         290    1      bug
## 428         290    2   ground
## 429         291    1      bug
## 430         291    2   flying
## 431         292    1      bug
## 432         292    2    ghost
## 433         293    1   normal
## 434         294    1   normal
## 435         295    1   normal
## 436         296    1 fighting
## 437         297    1 fighting
## 438         298    1   normal
## 439         298    2    fairy
## 440         299    1     rock
## 441         300    1   normal
## 442         301    1   normal
## 443         302    1     dark
## 444         302    2    ghost
## 445         303    1    steel
## 446         303    2    fairy
## 447         304    1    steel
## 448         304    2     rock
## 449         305    1    steel
## 450         305    2     rock
## 451         306    1    steel
## 452         306    2     rock
## 453         307    1 fighting
## 454         307    2  psychic
## 455         308    1 fighting
## 456         308    2  psychic
## 457         309    1 electric
## 458         310    1 electric
## 459         311    1 electric
## 460         312    1 electric
## 461         313    1      bug
## 462         314    1      bug
## 463         315    1    grass
## 464         315    2   poison
## 465         316    1   poison
## 466         317    1   poison
## 467         318    1    water
## 468         318    2     dark
## 469         319    1    water
## 470         319    2     dark
## 471         320    1    water
## 472         321    1    water
## 473         322    1     fire
## 474         322    2   ground
## 475         323    1     fire
## 476         323    2   ground
## 477         324    1     fire
## 478         325    1  psychic
## 479         326    1  psychic
## 480         327    1   normal
## 481         328    1   ground
## 482         329    1   ground
## 483         329    2   dragon
## 484         330    1   ground
## 485         330    2   dragon
## 486         331    1    grass
## 487         332    1    grass
## 488         332    2     dark
## 489         333    1   normal
## 490         333    2   flying
## 491         334    1   dragon
## 492         334    2   flying
## 493         335    1   normal
## 494         336    1   poison
## 495         337    1     rock
## 496         337    2  psychic
## 497         338    1     rock
## 498         338    2  psychic
## 499         339    1    water
## 500         339    2   ground
## 501         340    1    water
## 502         340    2   ground
## 503         341    1    water
## 504         342    1    water
## 505         342    2     dark
## 506         343    1   ground
## 507         343    2  psychic
## 508         344    1   ground
## 509         344    2  psychic
## 510         345    1     rock
## 511         345    2    grass
## 512         346    1     rock
## 513         346    2    grass
## 514         347    1     rock
## 515         347    2      bug
## 516         348    1     rock
## 517         348    2      bug
## 518         349    1    water
## 519         350    1    water
## 520         351    1   normal
## 521         352    1   normal
## 522         353    1    ghost
## 523         354    1    ghost
## 524         355    1    ghost
## 525         356    1    ghost
## 526         357    1    grass
## 527         357    2   flying
## 528         358    1  psychic
## 529         359    1     dark
## 530         360    1  psychic
## 531         361    1      ice
## 532         362    1      ice
## 533         363    1      ice
## 534         363    2    water
## 535         364    1      ice
## 536         364    2    water
## 537         365    1      ice
## 538         365    2    water
## 539         366    1    water
## 540         367    1    water
## 541         368    1    water
## 542         369    1    water
## 543         369    2     rock
## 544         370    1    water
## 545         371    1   dragon
## 546         372    1   dragon
## 547         373    1   dragon
## 548         373    2   flying
## 549         374    1    steel
## 550         374    2  psychic
## 551         375    1    steel
## 552         375    2  psychic
## 553         376    1    steel
## 554         376    2  psychic
## 555         377    1     rock
## 556         378    1      ice
## 557         379    1    steel
## 558         380    1   dragon
## 559         380    2  psychic
## 560         381    1   dragon
## 561         381    2  psychic
## 562         382    1    water
## 563         383    1   ground
## 564         384    1   dragon
## 565         384    2   flying
## 566         385    1    steel
## 567         385    2  psychic
## 568         386    1  psychic
## 569         387    1    grass
## 570         388    1    grass
## 571         389    1    grass
## 572         389    2   ground
## 573         390    1     fire
## 574         391    1     fire
## 575         391    2 fighting
## 576         392    1     fire
## 577         392    2 fighting
## 578         393    1    water
## 579         394    1    water
## 580         395    1    water
## 581         395    2    steel
## 582         396    1   normal
## 583         396    2   flying
## 584         397    1   normal
## 585         397    2   flying
## 586         398    1   normal
## 587         398    2   flying
## 588         399    1   normal
## 589         400    1   normal
## 590         400    2    water
## 591         401    1      bug
## 592         402    1      bug
## 593         403    1 electric
## 594         404    1 electric
## 595         405    1 electric
## 596         406    1    grass
## 597         406    2   poison
## 598         407    1    grass
## 599         407    2   poison
## 600         408    1     rock
## 601         409    1     rock
## 602         410    1     rock
## 603         410    2    steel
## 604         411    1     rock
## 605         411    2    steel
## 606         412    1      bug
## 607         413    1      bug
## 608         413    2    grass
## 609         414    1      bug
## 610         414    2   flying
## 611         415    1      bug
## 612         415    2   flying
## 613         416    1      bug
## 614         416    2   flying
## 615         417    1 electric
## 616         418    1    water
## 617         419    1    water
## 618         420    1    grass
## 619         421    1    grass
## 620         422    1    water
## 621         423    1    water
## 622         423    2   ground
## 623         424    1   normal
## 624         425    1    ghost
## 625         425    2   flying
## 626         426    1    ghost
## 627         426    2   flying
## 628         427    1   normal
## 629         428    1   normal
## 630         429    1    ghost
## 631         430    1     dark
## 632         430    2   flying
## 633         431    1   normal
## 634         432    1   normal
## 635         433    1  psychic
## 636         434    1   poison
## 637         434    2     dark
## 638         435    1   poison
## 639         435    2     dark
## 640         436    1    steel
## 641         436    2  psychic
## 642         437    1    steel
## 643         437    2  psychic
## 644         438    1     rock
## 645         439    1  psychic
## 646         439    2    fairy
## 647         440    1   normal
## 648         441    1   normal
## 649         441    2   flying
## 650         442    1    ghost
## 651         442    2     dark
## 652         443    1   dragon
## 653         443    2   ground
## 654         444    1   dragon
## 655         444    2   ground
## 656         445    1   dragon
## 657         445    2   ground
## 658         446    1   normal
## 659         447    1 fighting
## 660         448    1 fighting
## 661         448    2    steel
## 662         449    1   ground
## 663         450    1   ground
## 664         451    1   poison
## 665         451    2      bug
## 666         452    1   poison
## 667         452    2     dark
## 668         453    1   poison
## 669         453    2 fighting
## 670         454    1   poison
## 671         454    2 fighting
## 672         455    1    grass
## 673         456    1    water
## 674         457    1    water
## 675         458    1    water
## 676         458    2   flying
## 677         459    1    grass
## 678         459    2      ice
## 679         460    1    grass
## 680         460    2      ice
## 681         461    1     dark
## 682         461    2      ice
## 683         462    1 electric
## 684         462    2    steel
## 685         463    1   normal
## 686         464    1   ground
## 687         464    2     rock
## 688         465    1    grass
## 689         466    1 electric
## 690         467    1     fire
## 691         468    1    fairy
## 692         468    2   flying
## 693         469    1      bug
## 694         469    2   flying
## 695         470    1    grass
## 696         471    1      ice
## 697         472    1   ground
## 698         472    2   flying
## 699         473    1      ice
## 700         473    2   ground
## 701         474    1   normal
## 702         475    1  psychic
## 703         475    2 fighting
## 704         476    1     rock
## 705         476    2    steel
## 706         477    1    ghost
## 707         478    1      ice
## 708         478    2    ghost
## 709         479    1 electric
## 710         479    2    ghost
## 711         480    1  psychic
## 712         481    1  psychic
## 713         482    1  psychic
## 714         483    1    steel
## 715         483    2   dragon
## 716         484    1    water
## 717         484    2   dragon
## 718         485    1     fire
## 719         485    2    steel
## 720         486    1   normal
## 721         487    1    ghost
## 722         487    2   dragon
## 723         488    1  psychic
## 724         489    1    water
## 725         490    1    water
## 726         491    1     dark
## 727         492    1    grass
## 728         493    1   normal
## 729         494    1  psychic
## 730         494    2     fire
## 731         495    1    grass
## 732         496    1    grass
## 733         497    1    grass
## 734         498    1     fire
## 735         499    1     fire
## 736         499    2 fighting
## 737         500    1     fire
## 738         500    2 fighting
## 739         501    1    water
## 740         502    1    water
## 741         503    1    water
## 742         504    1   normal
## 743         505    1   normal
## 744         506    1   normal
## 745         507    1   normal
## 746         508    1   normal
## 747         509    1     dark
## 748         510    1     dark
## 749         511    1    grass
## 750         512    1    grass
## 751         513    1     fire
## 752         514    1     fire
## 753         515    1    water
## 754         516    1    water
## 755         517    1  psychic
## 756         518    1  psychic
## 757         519    1   normal
## 758         519    2   flying
## 759         520    1   normal
## 760         520    2   flying
## 761         521    1   normal
## 762         521    2   flying
## 763         522    1 electric
## 764         523    1 electric
## 765         524    1     rock
## 766         525    1     rock
## 767         526    1     rock
## 768         527    1  psychic
## 769         527    2   flying
## 770         528    1  psychic
## 771         528    2   flying
## 772         529    1   ground
## 773         530    1   ground
## 774         530    2    steel
## 775         531    1   normal
## 776         532    1 fighting
## 777         533    1 fighting
## 778         534    1 fighting
## 779         535    1    water
## 780         536    1    water
## 781         536    2   ground
## 782         537    1    water
## 783         537    2   ground
## 784         538    1 fighting
## 785         539    1 fighting
## 786         540    1      bug
## 787         540    2    grass
## 788         541    1      bug
## 789         541    2    grass
## 790         542    1      bug
## 791         542    2    grass
## 792         543    1      bug
## 793         543    2   poison
## 794         544    1      bug
## 795         544    2   poison
## 796         545    1      bug
## 797         545    2   poison
## 798         546    1    grass
## 799         546    2    fairy
## 800         547    1    grass
## 801         547    2    fairy
## 802         548    1    grass
## 803         549    1    grass
## 804         550    1    water
## 805         551    1   ground
## 806         551    2     dark
## 807         552    1   ground
## 808         552    2     dark
## 809         553    1   ground
## 810         553    2     dark
## 811         554    1     fire
## 812         555    1     fire
## 813         556    1    grass
## 814         557    1      bug
## 815         557    2     rock
## 816         558    1      bug
## 817         558    2     rock
## 818         559    1     dark
## 819         559    2 fighting
## 820         560    1     dark
## 821         560    2 fighting
## 822         561    1  psychic
## 823         561    2   flying
## 824         562    1    ghost
## 825         563    1    ghost
## 826         564    1    water
## 827         564    2     rock
## 828         565    1    water
## 829         565    2     rock
## 830         566    1     rock
## 831         566    2   flying
## 832         567    1     rock
## 833         567    2   flying
## 834         568    1   poison
## 835         569    1   poison
## 836         570    1     dark
## 837         571    1     dark
## 838         572    1   normal
## 839         573    1   normal
## 840         574    1  psychic
## 841         575    1  psychic
## 842         576    1  psychic
## 843         577    1  psychic
## 844         578    1  psychic
## 845         579    1  psychic
## 846         580    1    water
## 847         580    2   flying
## 848         581    1    water
## 849         581    2   flying
## 850         582    1      ice
## 851         583    1      ice
## 852         584    1      ice
## 853         585    1   normal
## 854         585    2    grass
## 855         586    1   normal
## 856         586    2    grass
## 857         587    1 electric
## 858         587    2   flying
## 859         588    1      bug
## 860         589    1      bug
## 861         589    2    steel
## 862         590    1    grass
## 863         590    2   poison
## 864         591    1    grass
## 865         591    2   poison
## 866         592    1    water
## 867         592    2    ghost
## 868         593    1    water
## 869         593    2    ghost
## 870         594    1    water
## 871         595    1      bug
## 872         595    2 electric
## 873         596    1      bug
## 874         596    2 electric
## 875         597    1    grass
## 876         597    2    steel
## 877         598    1    grass
## 878         598    2    steel
## 879         599    1    steel
## 880         600    1    steel
## 881         601    1    steel
## 882         602    1 electric
## 883         603    1 electric
## 884         604    1 electric
## 885         605    1  psychic
## 886         606    1  psychic
## 887         607    1    ghost
## 888         607    2     fire
## 889         608    1    ghost
## 890         608    2     fire
## 891         609    1    ghost
## 892         609    2     fire
## 893         610    1   dragon
## 894         611    1   dragon
## 895         612    1   dragon
## 896         613    1      ice
## 897         614    1      ice
## 898         615    1      ice
## 899         616    1      bug
## 900         617    1      bug
## 901         618    1   ground
## 902         618    2 electric
## 903         619    1 fighting
## 904         620    1 fighting
## 905         621    1   dragon
## 906         622    1   ground
## 907         622    2    ghost
## 908         623    1   ground
## 909         623    2    ghost
## 910         624    1     dark
## 911         624    2    steel
## 912         625    1     dark
## 913         625    2    steel
## 914         626    1   normal
## 915         627    1   normal
## 916         627    2   flying
## 917         628    1   normal
## 918         628    2   flying
## 919         629    1     dark
## 920         629    2   flying
## 921         630    1     dark
## 922         630    2   flying
## 923         631    1     fire
## 924         632    1      bug
## 925         632    2    steel
## 926         633    1     dark
## 927         633    2   dragon
## 928         634    1     dark
## 929         634    2   dragon
## 930         635    1     dark
## 931         635    2   dragon
## 932         636    1      bug
## 933         636    2     fire
## 934         637    1      bug
## 935         637    2     fire
## 936         638    1    steel
## 937         638    2 fighting
## 938         639    1     rock
## 939         639    2 fighting
## 940         640    1    grass
## 941         640    2 fighting
## 942         641    1   flying
## 943         642    1 electric
## 944         642    2   flying
## 945         643    1   dragon
## 946         643    2     fire
## 947         644    1   dragon
## 948         644    2 electric
## 949         645    1   ground
## 950         645    2   flying
## 951         646    1   dragon
## 952         646    2      ice
## 953         647    1    water
## 954         647    2 fighting
## 955         648    1   normal
## 956         648    2  psychic
## 957         649    1      bug
## 958         649    2    steel
## 959         650    1    grass
## 960         651    1    grass
## 961         652    1    grass
## 962         652    2 fighting
## 963         653    1     fire
## 964         654    1     fire
## 965         655    1     fire
## 966         655    2  psychic
## 967         656    1    water
## 968         657    1    water
## 969         658    1    water
## 970         658    2     dark
## 971         659    1   normal
## 972         660    1   normal
## 973         660    2   ground
## 974         661    1   normal
## 975         661    2   flying
## 976         662    1     fire
## 977         662    2   flying
## 978         663    1     fire
## 979         663    2   flying
## 980         664    1      bug
## 981         665    1      bug
## 982         666    1      bug
## 983         666    2   flying
## 984         667    1     fire
## 985         667    2   normal
## 986         668    1     fire
## 987         668    2   normal
## 988         669    1    fairy
## 989         670    1    fairy
## 990         671    1    fairy
## 991         672    1    grass
## 992         673    1    grass
## 993         674    1 fighting
## 994         675    1 fighting
## 995         675    2     dark
## 996         676    1   normal
## 997         677    1  psychic
## 998         678    1  psychic
## 999         679    1    steel
## 1000        679    2    ghost
## 1001        680    1    steel
## 1002        680    2    ghost
## 1003        681    1    steel
## 1004        681    2    ghost
## 1005        682    1    fairy
## 1006        683    1    fairy
## 1007        684    1    fairy
## 1008        685    1    fairy
## 1009        686    1     dark
## 1010        686    2  psychic
## 1011        687    1     dark
## 1012        687    2  psychic
## 1013        688    1     rock
## 1014        688    2    water
## 1015        689    1     rock
## 1016        689    2    water
## 1017        690    1   poison
## 1018        690    2    water
## 1019        691    1   poison
## 1020        691    2   dragon
## 1021        692    1    water
## 1022        693    1    water
## 1023        694    1 electric
## 1024        694    2   normal
## 1025        695    1 electric
## 1026        695    2   normal
## 1027        696    1     rock
## 1028        696    2   dragon
## 1029        697    1     rock
## 1030        697    2   dragon
## 1031        698    1     rock
## 1032        698    2      ice
## 1033        699    1     rock
## 1034        699    2      ice
## 1035        700    1    fairy
## 1036        701    1 fighting
## 1037        701    2   flying
## 1038        702    1 electric
## 1039        702    2    fairy
## 1040        703    1     rock
## 1041        703    2    fairy
## 1042        704    1   dragon
## 1043        705    1   dragon
## 1044        706    1   dragon
## 1045        707    1    steel
## 1046        707    2    fairy
## 1047        708    1    ghost
## 1048        708    2    grass
## 1049        709    1    ghost
## 1050        709    2    grass
## 1051        710    1    ghost
## 1052        710    2    grass
## 1053        711    1    ghost
## 1054        711    2    grass
## 1055        712    1      ice
## 1056        713    1      ice
## 1057        714    1   flying
## 1058        714    2   dragon
## 1059        715    1   flying
## 1060        715    2   dragon
## 1061        716    1    fairy
## 1062        717    1     dark
## 1063        717    2   flying
## 1064        718    1   dragon
## 1065        718    2   ground
## 1066        719    1     rock
## 1067        719    2    fairy
## 1068        720    1  psychic
## 1069        720    2    ghost
## 1070        721    1     fire
## 1071        721    2    water
## 1072      10001    1  psychic
## 1073      10002    1  psychic
## 1074      10003    1  psychic
## 1075      10004    1      bug
## 1076      10004    2   ground
## 1077      10005    1      bug
## 1078      10005    2    steel
## 1079      10006    1    grass
## 1080      10006    2   flying
## 1081      10007    1    ghost
## 1082      10007    2   dragon
## 1083      10008    1 electric
## 1084      10008    2     fire
## 1085      10009    1 electric
## 1086      10009    2    water
## 1087      10010    1 electric
## 1088      10010    2      ice
## 1089      10011    1 electric
## 1090      10011    2   flying
## 1091      10012    1 electric
## 1092      10012    2    grass
## 1093      10013    1     fire
## 1094      10014    1    water
## 1095      10015    1      ice
## 1096      10016    1    water
## 1097      10017    1     fire
## 1098      10017    2  psychic
## 1099      10018    1   normal
## 1100      10018    2 fighting
## 1101      10019    1   flying
## 1102      10020    1 electric
## 1103      10020    2   flying
## 1104      10021    1   ground
## 1105      10021    2   flying
## 1106      10022    1   dragon
## 1107      10022    2      ice
## 1108      10023    1   dragon
## 1109      10023    2      ice
## 1110      10024    1    water
## 1111      10024    2 fighting
## 1112      10025    1  psychic
## 1113      10026    1    steel
## 1114      10026    2    ghost
## 1115      10027    1    ghost
## 1116      10027    2    grass
## 1117      10028    1    ghost
## 1118      10028    2    grass
## 1119      10029    1    ghost
## 1120      10029    2    grass
## 1121      10030    1    ghost
## 1122      10030    2    grass
## 1123      10031    1    ghost
## 1124      10031    2    grass
## 1125      10032    1    ghost
## 1126      10032    2    grass
## 1127      10033    1    grass
## 1128      10033    2   poison
## 1129      10034    1     fire
## 1130      10034    2   dragon
## 1131      10035    1     fire
## 1132      10035    2   flying
## 1133      10036    1    water
## 1134      10037    1  psychic
## 1135      10038    1    ghost
## 1136      10038    2   poison
## 1137      10039    1   normal
## 1138      10040    1      bug
## 1139      10040    2   flying
## 1140      10041    1    water
## 1141      10041    2     dark
## 1142      10042    1     rock
## 1143      10042    2   flying
## 1144      10043    1  psychic
## 1145      10043    2 fighting
## 1146      10044    1  psychic
## 1147      10045    1 electric
## 1148      10045    2   dragon
## 1149      10046    1      bug
## 1150      10046    2    steel
## 1151      10047    1      bug
## 1152      10047    2 fighting
## 1153      10048    1     dark
## 1154      10048    2     fire
## 1155      10049    1     rock
## 1156      10049    2     dark
## 1157      10050    1     fire
## 1158      10050    2 fighting
## 1159      10051    1  psychic
## 1160      10051    2    fairy
## 1161      10052    1    steel
## 1162      10052    2    fairy
## 1163      10053    1    steel
## 1164      10054    1 fighting
## 1165      10054    2  psychic
## 1166      10055    1 electric
## 1167      10056    1    ghost
## 1168      10057    1     dark
## 1169      10058    1   dragon
## 1170      10058    2   ground
## 1171      10059    1 fighting
## 1172      10059    2    steel
## 1173      10060    1    grass
## 1174      10060    2      ice
## 1175      10061    1    fairy
## 1176      10062    1   dragon
## 1177      10062    2  psychic
## 1178      10063    1   dragon
## 1179      10063    2  psychic
## 1180      10064    1    water
## 1181      10064    2   ground
## 1182      10065    1    grass
## 1183      10065    2   dragon
## 1184      10066    1     dark
## 1185      10066    2    ghost
## 1186      10067    1   dragon
## 1187      10067    2    fairy
## 1188      10068    1  psychic
## 1189      10068    2 fighting
## 1190      10069    1   normal
## 1191      10069    2    fairy
## 1192      10070    1    water
## 1193      10070    2     dark
## 1194      10071    1    water
## 1195      10071    2  psychic
## 1196      10072    1    steel
## 1197      10072    2   ground
## 1198      10073    1   normal
## 1199      10073    2   flying
## 1200      10074    1      ice
## 1201      10075    1     rock
## 1202      10075    2    fairy
## 1203      10076    1    steel
## 1204      10076    2  psychic
## 1205      10077    1    water
## 1206      10078    1   ground
## 1207      10078    2     fire
## 1208      10079    1   dragon
## 1209      10079    2   flying
## 1210      10080    1 electric
## 1211      10081    1 electric
## 1212      10082    1 electric
## 1213      10083    1 electric
## 1214      10084    1 electric
## 1215      10085    1 electric
## 1216      10086    1  psychic
## 1217      10086    2     dark
## 1218      10087    1     fire
## 1219      10087    2   ground
## 1220      10088    1   normal
## 1221      10088    2 fighting
## 1222      10089    1   dragon
## 1223      10089    2   flying
## 1224      10090    1      bug
## 1225      10090    2   poison

NOTE: Join pokemon_types and types. pokemon_types gives pokemon id and their type id for slot 1 and 2. types gives the type names that correlate with the type id.

dbGetQuery(pokemonDatabase, "
           SELECT *
           FROM pokemon_types")
##      pokemon_id type_id slot
## 1             1      12    1
## 2             1       4    2
## 3             2      12    1
## 4             2       4    2
## 5             3      12    1
## 6             3       4    2
## 7             4      10    1
## 8             5      10    1
## 9             6      10    1
## 10            6       3    2
## 11            7      11    1
## 12            8      11    1
## 13            9      11    1
## 14           10       7    1
## 15           11       7    1
## 16           12       7    1
## 17           12       3    2
## 18           13       7    1
## 19           13       4    2
## 20           14       7    1
## 21           14       4    2
## 22           15       7    1
## 23           15       4    2
## 24           16       1    1
## 25           16       3    2
## 26           17       1    1
## 27           17       3    2
## 28           18       1    1
## 29           18       3    2
## 30           19       1    1
## 31           20       1    1
## 32           21       1    1
## 33           21       3    2
## 34           22       1    1
## 35           22       3    2
## 36           23       4    1
## 37           24       4    1
## 38           25      13    1
## 39           26      13    1
## 40           27       5    1
## 41           28       5    1
## 42           29       4    1
## 43           30       4    1
## 44           31       4    1
## 45           31       5    2
## 46           32       4    1
## 47           33       4    1
## 48           34       4    1
## 49           34       5    2
## 50           35      18    1
## 51           36      18    1
## 52           37      10    1
## 53           38      10    1
## 54           39       1    1
## 55           39      18    2
## 56           40       1    1
## 57           40      18    2
## 58           41       4    1
## 59           41       3    2
## 60           42       4    1
## 61           42       3    2
## 62           43      12    1
## 63           43       4    2
## 64           44      12    1
## 65           44       4    2
## 66           45      12    1
## 67           45       4    2
## 68           46       7    1
## 69           46      12    2
## 70           47       7    1
## 71           47      12    2
## 72           48       7    1
## 73           48       4    2
## 74           49       7    1
## 75           49       4    2
## 76           50       5    1
## 77           51       5    1
## 78           52       1    1
## 79           53       1    1
## 80           54      11    1
## 81           55      11    1
## 82           56       2    1
## 83           57       2    1
## 84           58      10    1
## 85           59      10    1
## 86           60      11    1
## 87           61      11    1
## 88           62      11    1
## 89           62       2    2
## 90           63      14    1
## 91           64      14    1
## 92           65      14    1
## 93           66       2    1
## 94           67       2    1
## 95           68       2    1
## 96           69      12    1
## 97           69       4    2
## 98           70      12    1
## 99           70       4    2
## 100          71      12    1
## 101          71       4    2
## 102          72      11    1
## 103          72       4    2
## 104          73      11    1
## 105          73       4    2
## 106          74       6    1
## 107          74       5    2
## 108          75       6    1
## 109          75       5    2
## 110          76       6    1
## 111          76       5    2
## 112          77      10    1
## 113          78      10    1
## 114          79      11    1
## 115          79      14    2
## 116          80      11    1
## 117          80      14    2
## 118          81      13    1
## 119          81       9    2
## 120          82      13    1
## 121          82       9    2
## 122          83       1    1
## 123          83       3    2
## 124          84       1    1
## 125          84       3    2
## 126          85       1    1
## 127          85       3    2
## 128          86      11    1
## 129          87      11    1
## 130          87      15    2
## 131          88       4    1
## 132          89       4    1
## 133          90      11    1
## 134          91      11    1
## 135          91      15    2
## 136          92       8    1
## 137          92       4    2
## 138          93       8    1
## 139          93       4    2
## 140          94       8    1
## 141          94       4    2
## 142          95       6    1
## 143          95       5    2
## 144          96      14    1
## 145          97      14    1
## 146          98      11    1
## 147          99      11    1
## 148         100      13    1
## 149         101      13    1
## 150         102      12    1
## 151         102      14    2
## 152         103      12    1
## 153         103      14    2
## 154         104       5    1
## 155         105       5    1
## 156         106       2    1
## 157         107       2    1
## 158         108       1    1
## 159         109       4    1
## 160         110       4    1
## 161         111       5    1
## 162         111       6    2
## 163         112       5    1
## 164         112       6    2
## 165         113       1    1
## 166         114      12    1
## 167         115       1    1
## 168         116      11    1
## 169         117      11    1
## 170         118      11    1
## 171         119      11    1
## 172         120      11    1
## 173         121      11    1
## 174         121      14    2
## 175         122      14    1
## 176         122      18    2
## 177         123       7    1
## 178         123       3    2
## 179         124      15    1
## 180         124      14    2
## 181         125      13    1
## 182         126      10    1
## 183         127       7    1
## 184         128       1    1
## 185         129      11    1
## 186         130      11    1
## 187         130       3    2
## 188         131      11    1
## 189         131      15    2
## 190         132       1    1
## 191         133       1    1
## 192         134      11    1
## 193         135      13    1
## 194         136      10    1
## 195         137       1    1
## 196         138       6    1
## 197         138      11    2
## 198         139       6    1
## 199         139      11    2
## 200         140       6    1
## 201         140      11    2
## 202         141       6    1
## 203         141      11    2
## 204         142       6    1
## 205         142       3    2
## 206         143       1    1
## 207         144      15    1
## 208         144       3    2
## 209         145      13    1
## 210         145       3    2
## 211         146      10    1
## 212         146       3    2
## 213         147      16    1
## 214         148      16    1
## 215         149      16    1
## 216         149       3    2
## 217         150      14    1
## 218         151      14    1
## 219         152      12    1
## 220         153      12    1
## 221         154      12    1
## 222         155      10    1
## 223         156      10    1
## 224         157      10    1
## 225         158      11    1
## 226         159      11    1
## 227         160      11    1
## 228         161       1    1
## 229         162       1    1
## 230         163       1    1
## 231         163       3    2
## 232         164       1    1
## 233         164       3    2
## 234         165       7    1
## 235         165       3    2
## 236         166       7    1
## 237         166       3    2
## 238         167       7    1
## 239         167       4    2
## 240         168       7    1
## 241         168       4    2
## 242         169       4    1
## 243         169       3    2
## 244         170      11    1
## 245         170      13    2
## 246         171      11    1
## 247         171      13    2
## 248         172      13    1
## 249         173      18    1
## 250         174       1    1
## 251         174      18    2
## 252         175      18    1
## 253         176      18    1
## 254         176       3    2
## 255         177      14    1
## 256         177       3    2
## 257         178      14    1
## 258         178       3    2
## 259         179      13    1
## 260         180      13    1
## 261         181      13    1
## 262         182      12    1
## 263         183      11    1
## 264         183      18    2
## 265         184      11    1
## 266         184      18    2
## 267         185       6    1
## 268         186      11    1
## 269         187      12    1
## 270         187       3    2
## 271         188      12    1
## 272         188       3    2
## 273         189      12    1
## 274         189       3    2
## 275         190       1    1
## 276         191      12    1
## 277         192      12    1
## 278         193       7    1
## 279         193       3    2
## 280         194      11    1
## 281         194       5    2
## 282         195      11    1
## 283         195       5    2
## 284         196      14    1
## 285         197      17    1
## 286         198      17    1
## 287         198       3    2
## 288         199      11    1
## 289         199      14    2
## 290         200       8    1
## 291         201      14    1
## 292         202      14    1
## 293         203       1    1
## 294         203      14    2
## 295         204       7    1
## 296         205       7    1
## 297         205       9    2
## 298         206       1    1
## 299         207       5    1
## 300         207       3    2
## 301         208       9    1
## 302         208       5    2
## 303         209      18    1
## 304         210      18    1
## 305         211      11    1
## 306         211       4    2
## 307         212       7    1
## 308         212       9    2
## 309         213       7    1
## 310         213       6    2
## 311         214       7    1
## 312         214       2    2
## 313         215      17    1
## 314         215      15    2
## 315         216       1    1
## 316         217       1    1
## 317         218      10    1
## 318         219      10    1
## 319         219       6    2
## 320         220      15    1
## 321         220       5    2
## 322         221      15    1
## 323         221       5    2
## 324         222      11    1
## 325         222       6    2
## 326         223      11    1
## 327         224      11    1
## 328         225      15    1
## 329         225       3    2
## 330         226      11    1
## 331         226       3    2
## 332         227       9    1
## 333         227       3    2
## 334         228      17    1
## 335         228      10    2
## 336         229      17    1
## 337         229      10    2
## 338         230      11    1
## 339         230      16    2
## 340         231       5    1
## 341         232       5    1
## 342         233       1    1
## 343         234       1    1
## 344         235       1    1
## 345         236       2    1
## 346         237       2    1
## 347         238      15    1
## 348         238      14    2
## 349         239      13    1
## 350         240      10    1
## 351         241       1    1
## 352         242       1    1
## 353         243      13    1
## 354         244      10    1
## 355         245      11    1
## 356         246       6    1
## 357         246       5    2
## 358         247       6    1
## 359         247       5    2
## 360         248       6    1
## 361         248      17    2
## 362         249      14    1
## 363         249       3    2
## 364         250      10    1
## 365         250       3    2
## 366         251      14    1
## 367         251      12    2
## 368         252      12    1
## 369         253      12    1
## 370         254      12    1
## 371         255      10    1
## 372         256      10    1
## 373         256       2    2
## 374         257      10    1
## 375         257       2    2
## 376         258      11    1
## 377         259      11    1
## 378         259       5    2
## 379         260      11    1
## 380         260       5    2
## 381         261      17    1
## 382         262      17    1
## 383         263       1    1
## 384         264       1    1
## 385         265       7    1
## 386         266       7    1
## 387         267       7    1
## 388         267       3    2
## 389         268       7    1
## 390         269       7    1
## 391         269       4    2
## 392         270      11    1
## 393         270      12    2
## 394         271      11    1
## 395         271      12    2
## 396         272      11    1
## 397         272      12    2
## 398         273      12    1
## 399         274      12    1
## 400         274      17    2
## 401         275      12    1
## 402         275      17    2
## 403         276       1    1
## 404         276       3    2
## 405         277       1    1
## 406         277       3    2
## 407         278      11    1
## 408         278       3    2
## 409         279      11    1
## 410         279       3    2
## 411         280      14    1
## 412         280      18    2
## 413         281      14    1
## 414         281      18    2
## 415         282      14    1
## 416         282      18    2
## 417         283       7    1
## 418         283      11    2
## 419         284       7    1
## 420         284       3    2
## 421         285      12    1
## 422         286      12    1
## 423         286       2    2
## 424         287       1    1
## 425         288       1    1
## 426         289       1    1
## 427         290       7    1
## 428         290       5    2
## 429         291       7    1
## 430         291       3    2
## 431         292       7    1
## 432         292       8    2
## 433         293       1    1
## 434         294       1    1
## 435         295       1    1
## 436         296       2    1
## 437         297       2    1
## 438         298       1    1
## 439         298      18    2
## 440         299       6    1
## 441         300       1    1
## 442         301       1    1
## 443         302      17    1
## 444         302       8    2
## 445         303       9    1
## 446         303      18    2
## 447         304       9    1
## 448         304       6    2
## 449         305       9    1
## 450         305       6    2
## 451         306       9    1
## 452         306       6    2
## 453         307       2    1
## 454         307      14    2
## 455         308       2    1
## 456         308      14    2
## 457         309      13    1
## 458         310      13    1
## 459         311      13    1
## 460         312      13    1
## 461         313       7    1
## 462         314       7    1
## 463         315      12    1
## 464         315       4    2
## 465         316       4    1
## 466         317       4    1
## 467         318      11    1
## 468         318      17    2
## 469         319      11    1
## 470         319      17    2
## 471         320      11    1
## 472         321      11    1
## 473         322      10    1
## 474         322       5    2
## 475         323      10    1
## 476         323       5    2
## 477         324      10    1
## 478         325      14    1
## 479         326      14    1
## 480         327       1    1
## 481         328       5    1
## 482         329       5    1
## 483         329      16    2
## 484         330       5    1
## 485         330      16    2
## 486         331      12    1
## 487         332      12    1
## 488         332      17    2
## 489         333       1    1
## 490         333       3    2
## 491         334      16    1
## 492         334       3    2
## 493         335       1    1
## 494         336       4    1
## 495         337       6    1
## 496         337      14    2
## 497         338       6    1
## 498         338      14    2
## 499         339      11    1
## 500         339       5    2
## 501         340      11    1
## 502         340       5    2
## 503         341      11    1
## 504         342      11    1
## 505         342      17    2
## 506         343       5    1
## 507         343      14    2
## 508         344       5    1
## 509         344      14    2
## 510         345       6    1
## 511         345      12    2
## 512         346       6    1
## 513         346      12    2
## 514         347       6    1
## 515         347       7    2
## 516         348       6    1
## 517         348       7    2
## 518         349      11    1
## 519         350      11    1
## 520         351       1    1
## 521         352       1    1
## 522         353       8    1
## 523         354       8    1
## 524         355       8    1
## 525         356       8    1
## 526         357      12    1
## 527         357       3    2
## 528         358      14    1
## 529         359      17    1
## 530         360      14    1
## 531         361      15    1
## 532         362      15    1
## 533         363      15    1
## 534         363      11    2
## 535         364      15    1
## 536         364      11    2
## 537         365      15    1
## 538         365      11    2
## 539         366      11    1
## 540         367      11    1
## 541         368      11    1
## 542         369      11    1
## 543         369       6    2
## 544         370      11    1
## 545         371      16    1
## 546         372      16    1
## 547         373      16    1
## 548         373       3    2
## 549         374       9    1
## 550         374      14    2
## 551         375       9    1
## 552         375      14    2
## 553         376       9    1
## 554         376      14    2
## 555         377       6    1
## 556         378      15    1
## 557         379       9    1
## 558         380      16    1
## 559         380      14    2
## 560         381      16    1
## 561         381      14    2
## 562         382      11    1
## 563         383       5    1
## 564         384      16    1
## 565         384       3    2
## 566         385       9    1
## 567         385      14    2
## 568         386      14    1
## 569         387      12    1
## 570         388      12    1
## 571         389      12    1
## 572         389       5    2
## 573         390      10    1
## 574         391      10    1
## 575         391       2    2
## 576         392      10    1
## 577         392       2    2
## 578         393      11    1
## 579         394      11    1
## 580         395      11    1
## 581         395       9    2
## 582         396       1    1
## 583         396       3    2
## 584         397       1    1
## 585         397       3    2
## 586         398       1    1
## 587         398       3    2
## 588         399       1    1
## 589         400       1    1
## 590         400      11    2
## 591         401       7    1
## 592         402       7    1
## 593         403      13    1
## 594         404      13    1
## 595         405      13    1
## 596         406      12    1
## 597         406       4    2
## 598         407      12    1
## 599         407       4    2
## 600         408       6    1
## 601         409       6    1
## 602         410       6    1
## 603         410       9    2
## 604         411       6    1
## 605         411       9    2
## 606         412       7    1
## 607         413       7    1
## 608         413      12    2
## 609         414       7    1
## 610         414       3    2
## 611         415       7    1
## 612         415       3    2
## 613         416       7    1
## 614         416       3    2
## 615         417      13    1
## 616         418      11    1
## 617         419      11    1
## 618         420      12    1
## 619         421      12    1
## 620         422      11    1
## 621         423      11    1
## 622         423       5    2
## 623         424       1    1
## 624         425       8    1
## 625         425       3    2
## 626         426       8    1
## 627         426       3    2
## 628         427       1    1
## 629         428       1    1
## 630         429       8    1
## 631         430      17    1
## 632         430       3    2
## 633         431       1    1
## 634         432       1    1
## 635         433      14    1
## 636         434       4    1
## 637         434      17    2
## 638         435       4    1
## 639         435      17    2
## 640         436       9    1
## 641         436      14    2
## 642         437       9    1
## 643         437      14    2
## 644         438       6    1
## 645         439      14    1
## 646         439      18    2
## 647         440       1    1
## 648         441       1    1
## 649         441       3    2
## 650         442       8    1
## 651         442      17    2
## 652         443      16    1
## 653         443       5    2
## 654         444      16    1
## 655         444       5    2
## 656         445      16    1
## 657         445       5    2
## 658         446       1    1
## 659         447       2    1
## 660         448       2    1
## 661         448       9    2
## 662         449       5    1
## 663         450       5    1
## 664         451       4    1
## 665         451       7    2
## 666         452       4    1
## 667         452      17    2
## 668         453       4    1
## 669         453       2    2
## 670         454       4    1
## 671         454       2    2
## 672         455      12    1
## 673         456      11    1
## 674         457      11    1
## 675         458      11    1
## 676         458       3    2
## 677         459      12    1
## 678         459      15    2
## 679         460      12    1
## 680         460      15    2
## 681         461      17    1
## 682         461      15    2
## 683         462      13    1
## 684         462       9    2
## 685         463       1    1
## 686         464       5    1
## 687         464       6    2
## 688         465      12    1
## 689         466      13    1
## 690         467      10    1
## 691         468      18    1
## 692         468       3    2
## 693         469       7    1
## 694         469       3    2
## 695         470      12    1
## 696         471      15    1
## 697         472       5    1
## 698         472       3    2
## 699         473      15    1
## 700         473       5    2
## 701         474       1    1
## 702         475      14    1
## 703         475       2    2
## 704         476       6    1
## 705         476       9    2
## 706         477       8    1
## 707         478      15    1
## 708         478       8    2
## 709         479      13    1
## 710         479       8    2
## 711         480      14    1
## 712         481      14    1
## 713         482      14    1
## 714         483       9    1
## 715         483      16    2
## 716         484      11    1
## 717         484      16    2
## 718         485      10    1
## 719         485       9    2
## 720         486       1    1
## 721         487       8    1
## 722         487      16    2
## 723         488      14    1
## 724         489      11    1
## 725         490      11    1
## 726         491      17    1
## 727         492      12    1
## 728         493       1    1
## 729         494      14    1
## 730         494      10    2
## 731         495      12    1
## 732         496      12    1
## 733         497      12    1
## 734         498      10    1
## 735         499      10    1
## 736         499       2    2
## 737         500      10    1
## 738         500       2    2
## 739         501      11    1
## 740         502      11    1
## 741         503      11    1
## 742         504       1    1
## 743         505       1    1
## 744         506       1    1
## 745         507       1    1
## 746         508       1    1
## 747         509      17    1
## 748         510      17    1
## 749         511      12    1
## 750         512      12    1
## 751         513      10    1
## 752         514      10    1
## 753         515      11    1
## 754         516      11    1
## 755         517      14    1
## 756         518      14    1
## 757         519       1    1
## 758         519       3    2
## 759         520       1    1
## 760         520       3    2
## 761         521       1    1
## 762         521       3    2
## 763         522      13    1
## 764         523      13    1
## 765         524       6    1
## 766         525       6    1
## 767         526       6    1
## 768         527      14    1
## 769         527       3    2
## 770         528      14    1
## 771         528       3    2
## 772         529       5    1
## 773         530       5    1
## 774         530       9    2
## 775         531       1    1
## 776         532       2    1
## 777         533       2    1
## 778         534       2    1
## 779         535      11    1
## 780         536      11    1
## 781         536       5    2
## 782         537      11    1
## 783         537       5    2
## 784         538       2    1
## 785         539       2    1
## 786         540       7    1
## 787         540      12    2
## 788         541       7    1
## 789         541      12    2
## 790         542       7    1
## 791         542      12    2
## 792         543       7    1
## 793         543       4    2
## 794         544       7    1
## 795         544       4    2
## 796         545       7    1
## 797         545       4    2
## 798         546      12    1
## 799         546      18    2
## 800         547      12    1
## 801         547      18    2
## 802         548      12    1
## 803         549      12    1
## 804         550      11    1
## 805         551       5    1
## 806         551      17    2
## 807         552       5    1
## 808         552      17    2
## 809         553       5    1
## 810         553      17    2
## 811         554      10    1
## 812         555      10    1
## 813         556      12    1
## 814         557       7    1
## 815         557       6    2
## 816         558       7    1
## 817         558       6    2
## 818         559      17    1
## 819         559       2    2
## 820         560      17    1
## 821         560       2    2
## 822         561      14    1
## 823         561       3    2
## 824         562       8    1
## 825         563       8    1
## 826         564      11    1
## 827         564       6    2
## 828         565      11    1
## 829         565       6    2
## 830         566       6    1
## 831         566       3    2
## 832         567       6    1
## 833         567       3    2
## 834         568       4    1
## 835         569       4    1
## 836         570      17    1
## 837         571      17    1
## 838         572       1    1
## 839         573       1    1
## 840         574      14    1
## 841         575      14    1
## 842         576      14    1
## 843         577      14    1
## 844         578      14    1
## 845         579      14    1
## 846         580      11    1
## 847         580       3    2
## 848         581      11    1
## 849         581       3    2
## 850         582      15    1
## 851         583      15    1
## 852         584      15    1
## 853         585       1    1
## 854         585      12    2
## 855         586       1    1
## 856         586      12    2
## 857         587      13    1
## 858         587       3    2
## 859         588       7    1
## 860         589       7    1
## 861         589       9    2
## 862         590      12    1
## 863         590       4    2
## 864         591      12    1
## 865         591       4    2
## 866         592      11    1
## 867         592       8    2
## 868         593      11    1
## 869         593       8    2
## 870         594      11    1
## 871         595       7    1
## 872         595      13    2
## 873         596       7    1
## 874         596      13    2
## 875         597      12    1
## 876         597       9    2
## 877         598      12    1
## 878         598       9    2
## 879         599       9    1
## 880         600       9    1
## 881         601       9    1
## 882         602      13    1
## 883         603      13    1
## 884         604      13    1
## 885         605      14    1
## 886         606      14    1
## 887         607       8    1
## 888         607      10    2
## 889         608       8    1
## 890         608      10    2
## 891         609       8    1
## 892         609      10    2
## 893         610      16    1
## 894         611      16    1
## 895         612      16    1
## 896         613      15    1
## 897         614      15    1
## 898         615      15    1
## 899         616       7    1
## 900         617       7    1
## 901         618       5    1
## 902         618      13    2
## 903         619       2    1
## 904         620       2    1
## 905         621      16    1
## 906         622       5    1
## 907         622       8    2
## 908         623       5    1
## 909         623       8    2
## 910         624      17    1
## 911         624       9    2
## 912         625      17    1
## 913         625       9    2
## 914         626       1    1
## 915         627       1    1
## 916         627       3    2
## 917         628       1    1
## 918         628       3    2
## 919         629      17    1
## 920         629       3    2
## 921         630      17    1
## 922         630       3    2
## 923         631      10    1
## 924         632       7    1
## 925         632       9    2
## 926         633      17    1
## 927         633      16    2
## 928         634      17    1
## 929         634      16    2
## 930         635      17    1
## 931         635      16    2
## 932         636       7    1
## 933         636      10    2
## 934         637       7    1
## 935         637      10    2
## 936         638       9    1
## 937         638       2    2
## 938         639       6    1
## 939         639       2    2
## 940         640      12    1
## 941         640       2    2
## 942         641       3    1
## 943         642      13    1
## 944         642       3    2
## 945         643      16    1
## 946         643      10    2
## 947         644      16    1
## 948         644      13    2
## 949         645       5    1
## 950         645       3    2
## 951         646      16    1
## 952         646      15    2
## 953         647      11    1
## 954         647       2    2
## 955         648       1    1
## 956         648      14    2
## 957         649       7    1
## 958         649       9    2
## 959         650      12    1
## 960         651      12    1
## 961         652      12    1
## 962         652       2    2
## 963         653      10    1
## 964         654      10    1
## 965         655      10    1
## 966         655      14    2
## 967         656      11    1
## 968         657      11    1
## 969         658      11    1
## 970         658      17    2
## 971         659       1    1
## 972         660       1    1
## 973         660       5    2
## 974         661       1    1
## 975         661       3    2
## 976         662      10    1
## 977         662       3    2
## 978         663      10    1
## 979         663       3    2
## 980         664       7    1
## 981         665       7    1
## 982         666       7    1
## 983         666       3    2
## 984         667      10    1
## 985         667       1    2
## 986         668      10    1
## 987         668       1    2
## 988         669      18    1
## 989         670      18    1
## 990         671      18    1
## 991         672      12    1
## 992         673      12    1
## 993         674       2    1
## 994         675       2    1
## 995         675      17    2
## 996         676       1    1
## 997         677      14    1
## 998         678      14    1
## 999         679       9    1
## 1000        679       8    2
## 1001        680       9    1
## 1002        680       8    2
## 1003        681       9    1
## 1004        681       8    2
## 1005        682      18    1
## 1006        683      18    1
## 1007        684      18    1
## 1008        685      18    1
## 1009        686      17    1
## 1010        686      14    2
## 1011        687      17    1
## 1012        687      14    2
## 1013        688       6    1
## 1014        688      11    2
## 1015        689       6    1
## 1016        689      11    2
## 1017        690       4    1
## 1018        690      11    2
## 1019        691       4    1
## 1020        691      16    2
## 1021        692      11    1
## 1022        693      11    1
## 1023        694      13    1
## 1024        694       1    2
## 1025        695      13    1
## 1026        695       1    2
## 1027        696       6    1
## 1028        696      16    2
## 1029        697       6    1
## 1030        697      16    2
## 1031        698       6    1
## 1032        698      15    2
## 1033        699       6    1
## 1034        699      15    2
## 1035        700      18    1
## 1036        701       2    1
## 1037        701       3    2
## 1038        702      13    1
## 1039        702      18    2
## 1040        703       6    1
## 1041        703      18    2
## 1042        704      16    1
## 1043        705      16    1
## 1044        706      16    1
## 1045        707       9    1
## 1046        707      18    2
## 1047        708       8    1
## 1048        708      12    2
## 1049        709       8    1
## 1050        709      12    2
## 1051        710       8    1
## 1052        710      12    2
## 1053        711       8    1
## 1054        711      12    2
## 1055        712      15    1
## 1056        713      15    1
## 1057        714       3    1
## 1058        714      16    2
## 1059        715       3    1
## 1060        715      16    2
## 1061        716      18    1
## 1062        717      17    1
## 1063        717       3    2
## 1064        718      16    1
## 1065        718       5    2
## 1066        719       6    1
## 1067        719      18    2
## 1068        720      14    1
## 1069        720       8    2
## 1070        721      10    1
## 1071        721      11    2
## 1072      10001      14    1
## 1073      10002      14    1
## 1074      10003      14    1
## 1075      10004       7    1
## 1076      10004       5    2
## 1077      10005       7    1
## 1078      10005       9    2
## 1079      10006      12    1
## 1080      10006       3    2
## 1081      10007       8    1
## 1082      10007      16    2
## 1083      10008      13    1
## 1084      10008      10    2
## 1085      10009      13    1
## 1086      10009      11    2
## 1087      10010      13    1
## 1088      10010      15    2
## 1089      10011      13    1
## 1090      10011       3    2
## 1091      10012      13    1
## 1092      10012      12    2
## 1093      10013      10    1
## 1094      10014      11    1
## 1095      10015      15    1
## 1096      10016      11    1
## 1097      10017      10    1
## 1098      10017      14    2
## 1099      10018       1    1
## 1100      10018       2    2
## 1101      10019       3    1
## 1102      10020      13    1
## 1103      10020       3    2
## 1104      10021       5    1
## 1105      10021       3    2
## 1106      10022      16    1
## 1107      10022      15    2
## 1108      10023      16    1
## 1109      10023      15    2
## 1110      10024      11    1
## 1111      10024       2    2
## 1112      10025      14    1
## 1113      10026       9    1
## 1114      10026       8    2
## 1115      10027       8    1
## 1116      10027      12    2
## 1117      10028       8    1
## 1118      10028      12    2
## 1119      10029       8    1
## 1120      10029      12    2
## 1121      10030       8    1
## 1122      10030      12    2
## 1123      10031       8    1
## 1124      10031      12    2
## 1125      10032       8    1
## 1126      10032      12    2
## 1127      10033      12    1
## 1128      10033       4    2
## 1129      10034      10    1
## 1130      10034      16    2
## 1131      10035      10    1
## 1132      10035       3    2
## 1133      10036      11    1
## 1134      10037      14    1
## 1135      10038       8    1
## 1136      10038       4    2
## 1137      10039       1    1
## 1138      10040       7    1
## 1139      10040       3    2
## 1140      10041      11    1
## 1141      10041      17    2
## 1142      10042       6    1
## 1143      10042       3    2
## 1144      10043      14    1
## 1145      10043       2    2
## 1146      10044      14    1
## 1147      10045      13    1
## 1148      10045      16    2
## 1149      10046       7    1
## 1150      10046       9    2
## 1151      10047       7    1
## 1152      10047       2    2
## 1153      10048      17    1
## 1154      10048      10    2
## 1155      10049       6    1
## 1156      10049      17    2
## 1157      10050      10    1
## 1158      10050       2    2
## 1159      10051      14    1
## 1160      10051      18    2
## 1161      10052       9    1
## 1162      10052      18    2
## 1163      10053       9    1
## 1164      10054       2    1
## 1165      10054      14    2
## 1166      10055      13    1
## 1167      10056       8    1
## 1168      10057      17    1
## 1169      10058      16    1
## 1170      10058       5    2
## 1171      10059       2    1
## 1172      10059       9    2
## 1173      10060      12    1
## 1174      10060      15    2
## 1175      10061      18    1
## 1176      10062      16    1
## 1177      10062      14    2
## 1178      10063      16    1
## 1179      10063      14    2
## 1180      10064      11    1
## 1181      10064       5    2
## 1182      10065      12    1
## 1183      10065      16    2
## 1184      10066      17    1
## 1185      10066       8    2
## 1186      10067      16    1
## 1187      10067      18    2
## 1188      10068      14    1
## 1189      10068       2    2
## 1190      10069       1    1
## 1191      10069      18    2
## 1192      10070      11    1
## 1193      10070      17    2
## 1194      10071      11    1
## 1195      10071      14    2
## 1196      10072       9    1
## 1197      10072       5    2
## 1198      10073       1    1
## 1199      10073       3    2
## 1200      10074      15    1
## 1201      10075       6    1
## 1202      10075      18    2
## 1203      10076       9    1
## 1204      10076      14    2
## 1205      10077      11    1
## 1206      10078       5    1
## 1207      10078      10    2
## 1208      10079      16    1
## 1209      10079       3    2
## 1210      10080      13    1
## 1211      10081      13    1
## 1212      10082      13    1
## 1213      10083      13    1
## 1214      10084      13    1
## 1215      10085      13    1
## 1216      10086      14    1
## 1217      10086      17    2
## 1218      10087      10    1
## 1219      10087       5    2
## 1220      10088       1    1
## 1221      10088       2    2
## 1222      10089      16    1
## 1223      10089       3    2
## 1224      10090       7    1
## 1225      10090       4    2
dbGetQuery(pokemonDatabase, "PRAGMA FOREIGN_KEY_LIST(pokemon_types)")
##   id seq   table       from to on_update on_delete match
## 1  0   0   types    type_id id NO ACTION NO ACTION  NONE
## 2  1   0 pokemon pokemon_id id NO ACTION NO ACTION  NONE
dbGetQuery(pokemonDatabase, "
           SELECT *
           FROM types")
##       id identifier generation_id damage_class_id
## 1      1     normal             1               2
## 2      2   fighting             1               2
## 3      3     flying             1               2
## 4      4     poison             1               2
## 5      5     ground             1               2
## 6      6       rock             1               2
## 7      7        bug             1               2
## 8      8      ghost             1               2
## 9      9      steel             2               2
## 10    10       fire             1               3
## 11    11      water             1               3
## 12    12      grass             1               3
## 13    13   electric             1               3
## 14    14    psychic             1               3
## 15    15        ice             1               3
## 16    16     dragon             1               3
## 17    17       dark             2               3
## 18    18      fairy             6              NA
## 19 10001    unknown             2              NA
## 20 10002     shadow             3              NA
dbGetQuery(pokemonDatabase, "PRAGMA FOREIGN_KEY_LIST(types)")
##   id seq               table            from to on_update on_delete match
## 1  0   0 move_damage_classes damage_class_id id NO ACTION NO ACTION  NONE
## 2  1   0         generations   generation_id id NO ACTION NO ACTION  NONE
dbDisconnect(pokemonDatabase)